View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Conditional Formatting for an entire row or column?

Highlight row
Conditional formatting
Change drop down to Formula Is
=$A1=yourvalue ... and choose your font to be red

This is assuming the first column is A

Hope this helps.
--
John C


"quinnj" wrote:

I would like to turn all cells a Fill color (e.g., Red) based on the value in
the first column of that row.