Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions | |||
Conditional Formatting based on Formula | Excel Worksheet Functions | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) |