VBA apply conditional formatting to another cell base on

harky

Active Member
Joined
Apr 8, 2010
Messages
288
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,132
Office Version
365
Platform
Windows
You can use conditional formatting to highlight a cell based on the value in a different cell.
What are you trying to do?
 

harky

Active Member
Joined
Apr 8, 2010
Messages
288
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,132
Office Version
365
Platform
Windows
But which cells do you want to highlight & why, what are the criteria?
 

harky

Active Member
Joined
Apr 8, 2010
Messages
288
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?
 
Last edited:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,132
Office Version
365
Platform
Windows
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

Active Member
Joined
Apr 8, 2010
Messages
288
ABCDEF
0010.1
0020.2
0030.3
0040.4
0050.5
0060.6
0070.7
0080.8
0090.9
1001.0

<tbody>
</tbody>


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

Active Member
Joined
Apr 8, 2010
Messages
288
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,132
Office Version
365
Platform
Windows
In that case select B1:B10 & in conditional formatting > New rule > Use a formula
=AND($F1>=0.1, $F1<=0.5)
 

harky

Active Member
Joined
Apr 8, 2010
Messages
288
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)
 

Forum statistics

Threads
1,077,686
Messages
5,335,656
Members
399,032
Latest member
thefinu

Some videos you may like

This Week's Hot Topics

Top