|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 23rd, 2004, 12:34 PM
|
|||
|
|||
Conditional Formatting
Hi all
I have this conditional format in cell BB35 =IF(BB35$BB$37,TRUE) If I insert cells between BB35 & BB37, then the formula changes to =IF(BB35$BB$38,TRUE) Is there a way of making BB37 absolute, or is there a formula using ROW that I could use? Many thanks -- George Gee -- 
|
|
#2
October 23rd, 2004, 01:13 PM
|
|||
|
|||
|
Select cell B35
Choose FormatConditional Formatting From the first dropdown, choose Formula Is In the formula box, type: =B35INDIRECT("$B$37") Click the Format button and select your formatting Click OK, click OK George Gee wrote: I have this conditional format in cell BB35 =IF(BB35$BB$37,TRUE) If I insert cells between BB35 & BB37, then the formula changes to =IF(BB35$BB$38,TRUE) Is there a way of making BB37 absolute, or is there a formula using ROW that I could use? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
|
|
#3
October 23rd, 2004, 01:19 PM
|
|||
|
|||
|
The formula should be: =BB35INDIRECT("BB37")
Debra Dalgleish wrote: Select cell B35 Choose FormatConditional Formatting From the first dropdown, choose Formula Is In the formula box, type: =B35INDIRECT("$B$37") Click the Format button and select your formatting Click OK, click OK George Gee wrote: I have this conditional format in cell BB35 =IF(BB35$BB$37,TRUE) If I insert cells between BB35 & BB37, then the formula changes to =IF(BB35$BB$38,TRUE) Is there a way of making BB37 absolute, or is there a formula using ROW that I could use? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
|
|
#4
October 23rd, 2004, 01:28 PM
|
|||
|
|||
|
Debra
Spot on! Many thanks George Gee *Debra Dalgleish* has posted this message: Select cell B35 Choose FormatConditional Formatting From the first dropdown, choose Formula Is In the formula box, type: =B35INDIRECT("$B$37") Click the Format button and select your formatting Click OK, click OK George Gee wrote: I have this conditional format in cell BB35 =IF(BB35$BB$37,TRUE) If I insert cells between BB35 & BB37, then the formula changes to =IF(BB35$BB$38,TRUE) Is there a way of making BB37 absolute, or is there a formula using ROW that I could use? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
|
|
#5
October 23rd, 2004, 01:30 PM
|
|||
|
|||
|
Debra
Yes, I did have the sense to alter that! Many thanks George Gee *Debra Dalgleish* has posted this message: The formula should be: =BB35INDIRECT("BB37") Debra Dalgleish wrote: Select cell B35 Choose FormatConditional Formatting From the first dropdown, choose Formula Is In the formula box, type: =B35INDIRECT("$B$37") Click the Format button and select your formatting Click OK, click OK George Gee wrote: I have this conditional format in cell BB35 =IF(BB35$BB$37,TRUE) If I insert cells between BB35 & BB37, then the formula changes to =IF(BB35$BB$38,TRUE) Is there a way of making BB37 absolute, or is there a formula using ROW that I could use? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
|
|
#6
October 23rd, 2004, 01:31 PM
|
|||
|
|||
|
You're welcome, and I'm glad you're more awake than I am!
George Gee wrote: Debra Yes, I did have the sense to alter that! Many thanks George Gee *Debra Dalgleish* has posted this message: The formula should be: =BB35INDIRECT("BB37") Debra Dalgleish wrote: Select cell B35 Choose FormatConditional Formatting From the first dropdown, choose Formula Is In the formula box, type: =B35INDIRECT("$B$37") Click the Format button and select your formatting Click OK, click OK George Gee wrote: I have this conditional format in cell BB35 =IF(BB35$BB$37,TRUE) If I insert cells between BB35 & BB37, then the formula changes to =IF(BB35$BB$38,TRUE) Is there a way of making BB37 absolute, or is there a formula using ROW that I could use? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Too much conditional formatting? | LJpse | General Discussion | 1 | November 8th, 2004 01:50 AM |
| Required Field Conditional | Katherine R | New Users | 2 | September 1st, 2004 05:52 AM |
| Pivots and keeping conditional formatting | Jenn | General Discussion | 1 | August 11th, 2004 10:35 PM |
| Copy Conditional Formatting | Bianca | Worksheet Functions | 2 | August 9th, 2004 01:47 PM |
Linear Mode
