Cell programming

  • Thread starter Thread starter Aaron Toponce
  • Start date Start date
A

Aaron Toponce

Is there a way in excel to type in conditional statements in a cell
block to determine font type and color?

EG:

if (balance > 0)
font = green;
else (if balance = 0)
font = black;
else
font = red;

This would be useful for using excel as a ledger for balancing
accounts. Any help would greatly be appreciated.

Aaron
 
For cells that you want to appear as described, FORMAT>CELL>CUSTOM and then
use [Green]#,##0.00_);[Red](#,##0.00);[Black]0.00

Dan
 
Back
Top