conditional formating of adjacent cells

[NigelW]

I would like to change the colour of a cell if certain conditions i
other cells are met, eg if cell a1="Sold" and b1>1000 and c1="horses
then can we change cell d1 to the colour blue (without changing th
text in d1). I would like to do this for a long list down th
worksheet.

Thanks in advance

Nige

 

[Peo Sjoblom]

Use formula is

=AND(A1="sold",B1>100,C1="horses")

select pattern and use the format painter to copy down
or select a range of cells with D1 as the active cell and then put in
the conditional formatting

 

[Alan]

In D1, Format on the toolbar > Conditional Formatting, select 'Formula Is"
=AND(A1="Sold",B1>1000,C1="Horses")
Select the format,
Regards,

 

[Bob Phillips]

Probably best to put the values in cells and refer to these, so it can be
tweaked with minimum effort

=AND(A1$H$1,B1>$H$2,C1=$H$3)

not the use of $.

--

HTH

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

In D1, Format on the toolbar > Conditional Formatting, select 'Formula Is"
=AND(A1="Sold",B1>1000,C1="Horses")
Select the format,
Regards,

 

[NigelW]

Thank you to everyone who took the time to reply, easy when you kno
what you are doing!!

Nige