VBA apply conditional formatting to another cell base on

harky

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

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,475
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
297
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
35,475
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
297
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
35,475
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
297
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
297
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
35,475
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
297
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,089,166
Messages
5,406,544
Members
403,096
Latest member
cyclingdad

This Week's Hot Topics

Top