Conditional Formatting

[George Gee]

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

 

[Debra Dalgleish]

Select cell B35
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type: =B35>INDIRECT("$B$37")
Click the Format button and select your formatting
Click OK, click OK

 

[Debra Dalgleish]

The formula should be: =BB35>INDIRECT("BB37")

Select cell B35
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type: =B35>INDIRECT("$B$37")
Click the Format button and select your formatting
Click OK, click OK

 

[George Gee]

Debra

Spot on!

Many thanks

George Gee


*Debra Dalgleish* has posted this message:

 

[George Gee]

Debra

Yes, I did have the sense to alter that!

Many thanks

George Gee



*Debra Dalgleish* has posted this message:

 

[Debra Dalgleish]

You're welcome, and I'm glad you're more awake than I am!

Debra

Yes, I did have the sense to alter that!

Many thanks

George Gee



*Debra Dalgleish* has posted this message: