Formula for using RYGB with certain criteria

Jeffrey Wagemans

Hi All,

Hope you guys can help me out. I'm trying to set up a formula where it looks at 2 dates and a checkbox and return certain outputs based on whats filled in.

So the main outputs should be:

• If Date 1 is empty and checkbox is empty = Blue
• If Date 1 is empty but checkbox is checked = Green
• If Date 1 is filled and checkbox is checked = Green
• If Date 1 is within 3 weeks of Date 2 and Checkbox isnt checked =Yellow
• If Date 1 isn't within 3 weeks of Date 2 and Checkbox isnt checked = Blue
• If Date 1 is within 2 weeks of Date 2 and Checkbox isnt checked = Red

Hope you guys can help me out!

Itai

Hey @Jeffrey Wagemans ,

Do you want the words "Blue", "Yellow"... to appear or do you want to use Conditional Formattion to color the row or cell?