if one cell greater than another cell, how to change colors?
hi
use conditional formating.
you didn't say how your data is layed out so...
if amt allotted is in column A and amt used is entered in column B then in
cell B1....
formatconditional format....
If cell value is......greater than.......=$A$1......Pick your color.
copy down column B - paste special - formats only
Regards
FSt1
"OS05" wrote:
For example:
I have an amount allotted: $900,000. Amount used exceeds amount limit. How
do I set it so that when the amount used is input and exceeds the amount
allotted, it will change colors?
|