Help with conditional formatting


G

Guest

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

Advertisements

D

Dave Peterson

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
 
Ad

Advertisements

G

Gord Dibben

Richard

Select the required cells in column B

Format>CF>Formula 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top