Conditional formatting formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Rose - 20 Mar 2006 23:42 GMT

I want to format the font color in cell G82 by checking the value in cell
D82. The value in cell D82 can be either blank, CAER followed by digits or
COR followed by digits. The formulas I wrote are:

Condition 1: =D82="" ; red font
Condition 2: =D82="C*" ; green font

The wildcard doesn't work. What change do I make to the formula?

TIA
David

Reply to this Message

Pete_UK - 20 Mar 2006 23:45 GMT

Try this for your second condition:

=LEFT(D82,1)="C"

Hope this helps.

Pete

Reply to this Message

David Rose - 21 Mar 2006 00:26 GMT

Sure, works like a charm. Why didn't I think of that?

> Try this for your second condition:
>
[quoted text clipped - 3 lines]
>
> Pete

Reply to this Message

Pete_UK - 21 Mar 2006 00:54 GMT

Thanks for feeding back.

Pete

Reply to this Message