Color Coding Amounts
 

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.

Color Coding Amounts
 

You would use Conditional Formatting

LizAnn wrote:

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.

Color Coding Amounts
 

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

"LizAnn" wrote:

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.

Color Coding Amounts
 

Thank you for your detailed information. I should be fine on using the
conditional format. Thank you again!!!!

"ScottBraunDesign" wrote:

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

"LizAnn" wrote:

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.

Color Coding Amounts
 

Thank You

"Bob I" wrote:

You would use Conditional Formatting

LizAnn wrote:

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.