Col F contains a unique value, "C", or an empty cell.
Select all rows or upper left to lower right cells
Format/Conditional Format
change "Cell Value Is" to "Formula Is"
enter =$F1="C" then select Format/Patterns and a color
Click Add and change Condition 2 to "Formula Is"
enter =$F1="" and select Format/Patterns and the "No Fill" option
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com