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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formating of adjacent cells 4
Excel Add ^ to a row of cells containing letters 3
Conditional Format II 3
Conditional Formatting for Dummies 4
Conditional formating more that 3 cells 2
Sum cells in columns based on condition 5
conditional formating adjacent rows 4
Conditional formatting macro 1

Top