Probably easy but I need help!

[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 :-

 

[djbob2k2]

Just have to use the

Format --> Conditional Formatting

Hooray.

Regards,

DjBob2K