Probably easy but I need help!

D

djbob2k2

I want to use the IF function, well any function that will make thi
work. I am generating a list and want to make it easier to shade th
cells so my formula that works for producing the word and not th
colour goes like this.

=IF(A1="Chief", "Red", "")

But I want this all over the sheet so kinda

=IF(A1,A7,A9="CHIEF", "RED", "")

If you can help that would be fantastic!

Thanks :-
 
Top