Conditional Format

[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!

 

[SteveG]

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

 

[SteveG]

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

 

[SteveG]

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

 

[SteveG]

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

 

[SteveG]

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