Help with conditional formatting Richard 24.09.2006 15:41:01 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!!

Re: Help with conditional formatting Dave Peterson <petersod[ at ]verizonXSPAM.net> 24.09.2006 16:07:47 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: [Quoted Text] > > 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!! -- Dave Peterson

Re: Help with conditional formatting Gord Dibben <gorddibbATshawDOTca> 24.09.2006 16:25:48 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 On Sun, 24 Sep 2006 08:41:01 -0700, Richard <Richard[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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!!