Formula Help

[iainems]

Hi,

Looking to create a formula return a text and format based on another cells date, but with 3 outcomes, I can only work in 2 based on the IF funcation.


I need the formula to do all of the following in one cell

If the date is less than today + 84 days then I want the cell to say BLUE and for the cell to go blue

If the date is > today +84 days , but less than 133 days then I want the cell to say RED and for the cell to go red

If the date is > 133 days then I want the cell to say Green and for the cell to go Green


Any experts that can help?

 

[vasim]

=IF(A1<TODAY()+84,"BLUE",IF(A1>TODAY()+133,"GREEN","RED"))


Use conditional formatting for formatting the cells


Goto Conditional formatting - select format only cell that contain - within it cell value equals to and select the appropriate format

 

[iainems]

Perfect, thank you very much.

 

[vasim]

Thanks....you are welcome