Help with Excel formula.

[TommyKingSTA]

I've recently spent quite a while trying to get the following formula to work and i finally have, but now i need to figure out how to not only change the text appearing in the cell but also the colour of that cell.

 

The formula is as follows:

 

=IF(COUNTIFS('Group Info'!C17:'Group Info'!F17,"<>"&"",'Group Info'!C17:'Group Info'!F17,"<>"&"Yes"),"Not Ready","Ready")

 

..This formula basically means that if all 4 cells on another worksheet ALL say 'Yes', then this cell will show 'Ready'. But, if any one of those cells doesnt say 'Yes' then to reply 'Not Ready'.

 

Now, can anyone help me with not only changing the text but also changing the colour of the cell to red if 'Not Ready' or green if 'Ready'?

 

Thanks.

[strawberry]

Conditional formatting will change the colour.

[Rob_D]

You can do this using conditional formatting in excel.

In 2016 (should be mostly the same in older versions), select the cell you want to format and go to Home Tab> Conditional Formatting> Highlight Cell Rules> Equal to. Then put "Not Ready" in the value and use pick a formatting type from the dropdown (or use custom). Then with the same cell selected go through the same process only using "Ready" and pick another formatting type.

[TommyKingSTA]

Ah of course! Thanks pal, forgot all about that! haha.