Conditional Formating on Row

L

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
 
F

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
 
B

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)

Frank Kabel said:
Hi
try the following:
- select the cells A2:H2
- goto the conditional format dialog and enter the formula
=$H2="New"
- choose your format
Click to expand...
 
Top