if one cell greater than another cell, how to change colors?
I have the allotted amount in one cell above the rest, then the amounts used
are broken down by days of the week below the allotted amount. I understand
that I probably have to format each cell, but would it still work in this
situation?
"FSt1" wrote:
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?
|