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


--
djbob2k2
------------------------------------------------------------------------
djbob2k2's Profile: http://www.excelforum.com/member.php...o&userid=27358
View this thread: http://www.excelforum.com/showthread...hreadid=468684