Select A1 to F2, then,
<Format <ConditionalFormat,
And choose "Formula Is", and enter this:
=A1=$G$1
Then choose your format, <OK <OK
And you should get what you asked.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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?
|