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

D

Dennis

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
 
F

Frank Kabel

Hi
- select cell P21
- goto 'Format - Conditional Format'
- enter the formula:
=M34=0
- choose a format (white color)
 
Top