Conditional Formating on Row

[loscherland]

Can you apply conditional formating to a number of colums in a ro
dependant on what information is enterd in a particular cell in tha
row.

Eg.

IF Cell H2 = "New" then Format text in cells A2:H2 as 'Red' 'Bold

 

[Frank Kabel]

Hi
try the following:
- select the cells A2:H2
- goto the conditional format dialog and enter the formula
=$H2="New"
- choose your format

 

[Bob Phillips]

Don't forget to change from a Condition to Formula Is.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi
try the following:
- select the cells A2:H2
- goto the conditional format dialog and enter the formula
=$H2="New"
- choose your format