how do I create formula for if a valuegreater that zero is added it shades another cell?

T

tsunnyvale

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel how do I create formula for - if a value greater that zero is added in one cell it shades another cell?
 
C

Carl Witthoft

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

how do I create formula for - if a value greater that zero is added in one
cell it shades another cell?
Click to expand...

Use Conditional Formatting in the cell you want shaded. Then you just
need to set up a formula in the Conditional FOrmatting setup box for the
cell you want to change color.
Something along the lines of (where A1 is the cell where you're
checking the value)

IF( A1 >0,1,0)==1


Carl
 
Top