PDA

View Full Version : Highlight Row Based on Cell Value



agnesz
09-29-2009, 09:24 AM
Hi there -
How can I get the whole row highlighted in black with white font, whenever any cell in column D or F contains the word "Total".
Thanks a million as always.

Bob Phillips
09-29-2009, 10:17 AM
Conditional formatting

See http://www.contextures.com/xlDataVal01.html