How do i change the color of a cell based on the value of anthor c

[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.

 

[David Adamson]

Look at

http://www.cpearson.com/excel/colors.htm

I would advise using the The Case Statement

-------------
value = cell m34

Select Case Value

Case 0
cell21.Interior.ColorIndex = 3 'red
'change Colourindex to get different coulrs

Case 1 to 10

Case Else

End select