Change text colour when entry made in another cell

**thalt** · 01-10-2010, 02:30 AM

Hi All
I am using Excel 2003, my problem is that I have cells D4 & E4 with red text, when an entry is made in B4 (say $640, the amount can vary) I want the text in D4 & E4 to turn black.

I have attached a section of the document in question.

TIA thalt

**JBeaucaire** · 01-10-2010, 03:02 AM

You question doesn't match your sample sheet. Can you clarify your cells to match?

I'll take a stab:

1) Highlight F1:G1000
2) Click on Format > Conditional Formatting
3) Use these parameters:
Condition1 > Formula Is: =$D1<>""
Format... Font tab: Black

Resist applying conditional formatting to entire columns unless you know you're going to have 65000 rows of data soon.

**pike** · 01-10-2010, 03:05 AM

could use conditional formating
=not(isblank(Range)) Font Clour red
= isblank(Range) Font colour Black

**pike** · 01-10-2010, 03:10 AM

ops just need to use
with the cell colour on automatic
=not(isblank(Range)) Font Clour red

**pike** · 01-10-2010, 03:18 AM

I'll get it right
after testing
with the cell colour on automatic
=isblank(Range) Font Colour red

**thalt** · 01-10-2010, 07:13 AM

Thank you both for your prompt and excellent replies, they both gave me what I was looking for and will save me a lot of tedious work.

Abundant thanks once again, your help is appreciated. thalt