Help with conditional formatting
 

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,B 30
Thanks in advance!!

Help with conditional formatting
 

Select your range (B3, b7, ...)
You can click on the first cell and ctrl-click on the subsequent cells

Then format|conditional formatting
formula is:
=OR($F$1=5,$O$1=5000)

And give it a nice format

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,B 30
Thanks in advance!!

--

Dave Peterson

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!!