Text Color Change - Cell by cell basis - when budget is reached

**bcart82** · 01-20-2009, 02:53 PM

Hi All!

New guy to the forum. I'm a business/application consultant for ERP software, and generally pretty solid when it comes to excel. However, I've come across a question for a personal sheet that I can't seem to solve.

In my personal budget worksheet, I'd like to set a budget on a cell-by-cell basis. When the budget is hit, I'd like the text color (or cell color) to change.

I.E. Cell D14 has a budget of $200. When I enter $200 in the cell, the text turns from black to red.

I've searched through google with no luck. I have mildly searched this forum, but haven't found my direct answer - I have come pretty close though, in other languages

Any help?

TIA!

**JBeaucaire** · 01-20-2009, 02:58 PM

Highlight the cell, click FORMAT > CONDITIONAL FORMATTTING > Condition1:

Cell Value Is - Greater than or equal to - 200

Click Format and set font color to red.

**navigator25** · 01-20-2009, 02:58 PM

you should be able to use the conditional formatting to make the cell by cell colors change. There may be an easier way to do this but thats how i would do it.

**bcart82** · 01-20-2009, 03:01 PM

Originally Posted by JBeaucaire

Highlight the cell, click FORMAT > CONDITIONAL FORMATTTING > Condition1:

Cell Value Is - Greater than or equal to - 200

Click Format and set font color to red.

Ahhhhh! So happy

Thank you very much!