conditional colour formating of adjacent cells

N

NigelW

I am trying to format a cell if adjacent cells satisfy certain criteria
For example if cell a1="blue" and b1>1000 and c1="horses" then colou
d1 orange, or some other constant predetermined colour withou
affecting the text in d1.

Thanks in advance

Nige
 
F

Frank Kabel

Hi
try the following:
- select cell D1
- goto 'Format - Conditional Format'
- enter the following formula
=(A1="blue")*(B1>1000)*(C1="horses")
- choose a format
 
Top