color

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.
 

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
how do i change the color of a cell auotmatically? 2
how to change color of a cell based on the value of anthor cell 1
Conditional Formatting with VBA 4
Copy colored cell to a second page 1
Comparing Values from One Cell to Another 1
Macro to change color of tab based on color of cell 5
Why excel cell color did not change after formatting and VBA code? 7

Top