Conditional formatting formula
 

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 a

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

Conditional formatting formula
 

Try this for your second condition:

=LEFT(D82,1)="C"

Hope this helps.

Pete

Conditional formatting formula
 

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

"Pete_UK" wrote in message
oups.com...
Try this for your second condition:

=LEFT(D82,1)="C"

Hope this helps.

Pete

Conditional formatting formula
 

Thanks for feeding back.

Pete