Probably easy but I need help!

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

:-)

Just have to use the

Format --> Conditional Formatting :-)

Hooray.

Regards,

DjBob2K2