conditional colour formating of adjacent cells

  • Thread starter Thread starter NigelW
  • Start date Start date
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
 
Hi
try the following:
- select cell D1
- goto 'Format - Conditional Format'
- enter the following formula
=(A1="blue")*(B1>1000)*(C1="horses")
- choose a format
 
Back
Top