Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |