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