Change the color of text when a value is present in a cell.

[tbtcust]

Hi all,
I would like excel to change the text from normal to red when a negative number is in a that cell.

I would also like excel to change text from normal to blue when a string is present in that cell.

Is this possible to have excel do this automatically?


Thanks in advance for any help.

 

[KenWright]

Select cells to be formatted and then

Format / Conditional Formatting.

Rule 1 - If cell value is less than 0 then RED FONT
Rule 2 - Cell FORMULA is =ISTEXT(Cell Ref of Upper left of range to be formatted)

OR

just apply a custom format of:-

#,##0.00;[Red]-#,##0.00;0.00;[Blue]General

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[tbtcust]

Thanks Ken. The Format / Conditional Formatting works well.

 

[KenWright]

You're welcome

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[GlennUK]

Just for interest, a Custom Number format of:
#,##0;[Red]-#,##0;0;[Blue]@

will do the same.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.