Forum Discussion
Solved
IF Function
I am trying to use an IF function that looks at words rather than numbers. I would like the function to look at the data range B4:B20 and if they all have Yes typed in I would like the function to di...
Hi
=IF(COUNTIF(B4:B20,"Yes")=ROWS(B4:B20),"Certified","Training needed")
Thank you that worked! I would also like to make them colored. If it returns Certified, can it automatically turn the box green and if it returns Training Needed, can it turn the box red?
Change the fill color of the cell to green.
Apply a new rule for conditional formatting.
Instead of A (in this example) type Trainig needed and set the format to fill color red.
Of course you can also do it the other way round.