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?

 

[Fluff]

You can use conditional formatting to highlight a cell based on the value in a different cell.
What are you trying to do?

 

[harky]

The data which i want to highlight is at Col B
but i cant use Col B on conditional formatting because there is no range data (number).

My range data is located at Col F

You can use conditional formatting to highlight a cell based on the value in a different cell.
What are you trying to do?

 

[Fluff]

But which cells do you want to highlight & why, what are the criteria?

 

[harky]

highlight is at Col B

data is located at Col F

The reason is Col B cannot use formula, is like a data of code number so i cant use it.

But which cells do you want to highlight & why, what are the criteria?

 

[Fluff]

You can still highlight col B using conditional formatting, but if you don't tell me what the criteria are, I cannot help.
So I will ask you once more, what are the criteria?

 

[harky]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.1[/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.2[/TD]
[/TR]
[TR]
[TD]003[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.3[/TD]
[/TR]
[TR]
[TD]004[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.4[/TD]
[/TR]
[TR]
[TD]005[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.5[/TD]
[/TR]
[TR]
[TD]006[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.6[/TD]
[/TR]
[TR]
[TD]007[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.7[/TD]
[/TR]
[TR]
[TD]008[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD]009[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.9[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1.0[/TD]
[/TR]
</tbody>[/TABLE]


I used conditional formatting on Col F

It suppose to highlight Col A if Col F is between 0.1 to 0.5 (let say green colour)

=AND($F1>=0.1,<=0.5)

 

[harky]

something like below?

each range used diff colour.

You can still highlight col B using conditional formatting, but if you don't tell me what the criteria are, I cannot help.
So I will ask you once more, what are the criteria?

 

[Fluff]

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

 

[harky]

oh haha..

i dont know tht can be done like this.
i sound silly.

Thanks

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