how do i change the color of a cell auotmatically?

D

Dennis

I am desiging a data shee and i want to changes the color of a cell based on
the valuse of anthor cell.

ex. if "cell m34" is equal to 0 then "cell p21" is white, if cell m34 less
than 1548, then "cell P21" is yellow

Can this be done? If so, please help me out.
 
B

Biff

Hi!

Select cell P21
Goto Format>Conditional Formatting
In the dropdown select Formula is
Enter this formula in the box: =AND(M34<>"",M34=0)
Click the Format button and select the style to apply then
click OK.
Click the Add button
In Condition 2
Formula is: =AND(M34>=1,M34<=1548)
Select the format style to apply to that condition then OK
out

Biff
 

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

How do i change the color of a cell based on the value of anthor c 1
color 1
how to change color of a cell based on the value of anthor cell 1
How to filter rows data based on background color of individual cells 3
Changing cell colors 1
Conditional format color change 2
How do I change the color the cell becomes when doing a FIND 4
Conditional Formating based on Date 5

Top