Help with conditional formatting
Richard
Select the required cells in column B
FormatCFFormula is: =OR($F$1=5,$O$1=5000)
The $ signs are a must.
Format to a red pattern and OK out.
Gord Dibben MS Excel MVP
On Sun, 24 Sep 2006 08:41:01 -0700, Richard
wrote:
How would you write this formula to show in red?
If F1 = 5 OR O1 = 5000 then conditional format these cells in red.
B3,B7,B8,B13,B14,B17,B19,B20,B21,B22,B23,B24,B28, B30
Thanks in advance!!
|