View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
OS05 OS05 is offline
external usenet poster
 
Posts: 2
Default 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?