Help -how would I highlight rows based on column value

crag8119

New Member
Joined
Mar 25, 2014
Messages
38
Hi,

I have different values in column D, if a row in column C or F contains a value from column D I want to highlight the entire row. How do I write a formula for this or Marco?

Many thanks
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,925
Office Version
  1. 365
Platform
  1. MacOS
conditional formatting should do that

Is
this the same row -
ie
column D3 has 20 in
column C3 has 20 in
then highlight row 3
or
ie
column D8 has "fred" in
column F8 has "fred" in
then highlight row 8

or does it matter where it is
ie
column D8 has "fred" in
column F212 has "fred" in
then highlight row 8

With conditional formatting
you can use a formula
=select the range - say A1 to Z2000
use a formula
=AND( $D1 <> "" , OR( $D1 = $C1, $D1 = $F1 ) )

will check each row

different if the value can be anywhere, would use a countif() formula - but let us know
 

Watch MrExcel Video

Forum statistics

Threads
1,108,991
Messages
5,526,105
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top