Conditional Format

  • Thread starter Thread starter Steph
  • Start date Start date
S

Steph

Can this be done with a conditional format?
Data in columns A thru C. I would like the highlight the cells in column C
where the same data exists in either columns A or B.

For example, Cell C5 has the number 75. If any cell within columns A or B
also have 75, then highlight C5.

Thanks!
 
In the CF change the Cell Value is to Formula Is


=OR(COUNTIF($A$1:$A$100,C5)>0,COUNTIF($B$1:$B$100,C5)>0)

Select Format, Patterns select your fill color then OK, OK.

-or-

=OR(MATCH(C5,A1:A100,0)>0,MATCH(C5,B1:B100,0)>0)

Select Format, Patterns select your fill color then OK, OK.

Format down your list.

HTH

Steve
 
In the CF change the Cell Value is to Formula Is


=OR(COUNTIF($A$1:$A$100,C5)>0,COUNTIF($B$1:$B$100,C5)>0)

Select Format, Patterns select your fill color then OK, OK.

-or-

=OR(MATCH(C5,A1:A100,0)>0,MATCH(C5,B1:B100,0)>0)

Select Format, Patterns select your fill color then OK, OK.

Format down your list.

HTH

Steve
 
In the CF change the Cell Value is to Formula Is


=OR(COUNTIF($A$1:$A$100,C5)>0,COUNTIF($B$1:$B$100,C5)>0)

Select Format, Patterns select your fill color then OK, OK.

-or-

=OR(MATCH(C5,A1:A100,0)>0,MATCH(C5,B1:B100,0)>0)

Select Format, Patterns select your fill color then OK, OK.

Format down your list.

HTH

Steve
 
In the CF change the Cell Value is to Formula Is


=OR(COUNTIF($A$1:$A$100,C5)>0,COUNTIF($B$1:$B$100,C5)>0)

Select Format, Patterns select your fill color then OK, OK.

-or-

=OR(MATCH(C5,A1:A100,0)>0,MATCH(C5,B1:B100,0)>0)

Select Format, Patterns select your fill color then OK, OK.

Format down your list.

HTH

Steve
 
Actually, don't use the MATCH as it returns an error when 75 is in one
but not the other and won't fill your cell as desired.

Steve
 
Back
Top