View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Conditional Formatting (Excel 2007) Format Row Color Based on X

Select your range of cells, Format/ CF/ Formula Is:
=$A1="X"

Note the absolute reference for the column.
--
David Biddulph

"Alice M." wrote in message
...
I have a row with data spanning 6 columns. Each Col is formatted
differently
(some as date, text, or numbers.)

How do I change the entire row to a color if the entry in Col A (formatted
as text) is equal to X? (If I try to copy Col A's format across the row,
it
changes the formatting in the other Cols all to text.)

Thx,