Thread: How do I use conditional formatting to colour rows of data?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default How do I use conditional formatting to colour rows of data?
Hi Simon,

If your reference cell is A5, and the "correct value" equals say 2006,
then

Use Conditional Formatting
Formula is
=MATCH(2006,$A5,0)
Format as you wish
and copy to all the cells in this very same row which should be
colorized ...

HTH
Cheers
Carim


Simon wrote:
I would like to use conditional formatting to highlight an entire row of data
based on the value being correct in one cell.

Reply With QuoteReply With Quote