View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Conditional Formatting

Highlight A - G.

Conditional Formatting...

Pick:
Formula Is

enter:
=$G1="K"

Format, pick your fonts.

Same for the others.

The key is to retain the $ before the G.

"Philip Drury" wrote:

I want to change the colour of cells A1:G1 if the value of G1 is K (make the
row green), U (make the row amber) or S (make the row red). Really want this
to apply to each row below as the relevant G value is input.
Does that make sense?