Conditional Highlighting

wmtsub

Active Member
Joined
Jun 20, 2018
Messages
322
Is it possible to highlight the entire row if 1 cell equals a specific value using the Conditional Formatting
feature built in?
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hi,

Yes ...

You can have following formula : =$A1="MySpecificText"

Hope this will help
 

wmtsub

Active Member
Joined
Jun 20, 2018
Messages
322
Not sure where / how to applly this. In the conditional formatting I am hightlighing not adding text.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,760
Office Version
365
Platform
Windows
What column has the values you want to check?
What range do you want to highlight?
What is the value?
 

wmtsub

Active Member
Joined
Jun 20, 2018
Messages
322
The colum is "B", three seperate values, CAM - HUSE - VDR.
The range of teh row vaires - higlighting the entier row wuould be great.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,760
Office Version
365
Platform
Windows
Select the range of cells you want this to work on & use this formula
=OR($B2="CAM",$B2="VDR",$B2="HUSE")
Assumes that the first row selected above is row2
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,760
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,095,748
Messages
5,446,266
Members
405,392
Latest member
Steveoaktree1977

This Week's Hot Topics

Top