Conditional Formatting

  • Thread starter Thread starter George Gee
  • Start date Start date
G

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
 
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
 
The formula should be: =BB35>INDIRECT("BB37")

Debra said:
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
Click to expand...
 
Debra

Yes, I did have the sense to alter that!

Many thanks

George Gee



*Debra Dalgleish* has posted this message:
 
You're welcome, and I'm glad you're more awake than I am!

George said:
Debra

Yes, I did have the sense to alter that!

Many thanks

George Gee



*Debra Dalgleish* has posted this message:
Click to expand...
 
Back
Top