how do i change the color of a cell auotmatically?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

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
Sorting VBA problem 6
Change Color of cell 3
Changing cell colors 1
Conditional format color change 2
How do I change the color the cell becomes when doing a FIND 4

Back
Top