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
 

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

Formula Question 3
subtraction formula 4
Using COUNTIF but blank cell if zero 3
In cell editing 2
Zero values 1
Microsoft Excel 2008 for Mac 3
How do I align currency decimals in cells? 2
Where is formula bar? 3

Top