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