Color Coding Amounts

  • Thread starter Thread starter LizAnn
  • Start date Start date
L

LizAnn

I have an excel spreadsheet that someone else created. It is a budget. When
the $ amount spent is under the budget, the cell stays highlighted in green.
When it goes over the budget up to 5%, it automatically highlights in yellow
and when the budget goes over 5% or more, the cell automatically highlights
in red. Does anyone know how to do this? Thanks.
 
Conditional formatting, Try Selecting your cells you want this to happen with
click on format, and conditional formatting. there you can set values and
format the result if the value is met, if you need more specifics let me
know, i'll get more detailed, give it try
 
Thank you for your detailed information. I should be fine on using the
conditional format. Thank you again!!!!
 
Back
Top