formula=
=a1=$g$5
format as desireduse format painter to copy to other cells

--
Don Guillett
SalesAid Software

"Sibbs" wrote in message
...
I am trying to highlight cells that match

ie

a b c d e f g
6 0 4 5 6 8 5
2 5 2 3 7 9


I want, if 5 is placed in the g cell (whatever line, lets say line 1) it
will highlight the d cell in line 1 and the b cell in line 2.

Am I making sense?