VBA apply conditional formatting to another cell base on

[harky]

The conditional formatting is base on Col F to change colour.

But due to Col B is not in a range so i cant use conditional formatting.

Possible to use VBA apply conditional formatting base on Col F to Col B, without change any Col B data?

 

[harky]

Is tht possible to highlight both side?

Col B & Col F?

In that case select B1:B10 & in conditional formatting > New rule > Use a formula
=AND($F1>=0.1, $F1<=0.5)

 

[Fluff]

Just select both columns before adding the rule

 

[harky]

tested.

thank u so much

Just select both columns before adding the rule

 

[Fluff]

My pleasure & thanks for the feedback

 

[harky]

what is the formaular for not wanted to hightlight 3 digital number?

 

[Fluff]

In what way?

 

[harky]

Thanks!

I manage to get it.

=Len(C1)>3

In what way?

 

[Fluff]

Glad you sorted it & thanks for the feedback