Help -how would I highlight rows based on column value

[crag8119]

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

 

[etaf]

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