how to change color of a cell based on the value of anthor cell

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

Guest

i would like to change the color of a cell based on the value of anthor cell

If "cell m34" if equal to 0, then "cell p21" is white
If "cell m34" is less than 1845, then "cell p21" is yellow

Please help me out with this.
Thank you
 
Hi
- select cell P21
- goto 'Format - Conditional Format'
- enter the formula:
=M34=0
- choose a format (white color)
 
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
how do i change the color of a cell auotmatically? 2
color 1
Changing Cell Color Based on Value 2
create a formula based on cell color 2
How to Color a Cell Based on a Range of Cells with Colors 1
IF(ISBLANK question 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top