Conditional formatting with text
Posted on 2013-11-26
I have applied a Conditional Format with the formatting of my choice using the Select a Rule option:
No problem - works fine.
This Conditional Formatting applies to the range K3:M15. The range M3:M15 represents a column labeled Status. My objective is that when the condition is satified the column labeled Status (M3:M15) for the range satisfied would read OK and the balance would be "Estimate".
For example if K3:M10 met the condition then M3:M10 would read "OK" and M11:M15 would read "Estimate".
The range M3:M15 is blank but I do have data in the range K3:L15