I want to use the IF function, well any function that will make this work. I am generating a list and want to make it easier to shade the cells so my formula that works for producing the word and not the 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 :-)