Conditional format
 

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?

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?

Hi

highlight from A1 to F2
choose format / conditional formatting
choose formula is
type
=A1=$G$1
...press the format button - choose formatting OK twice

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"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?

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?

Got it and it works, thanks for replying Don

"Don Guillett" wrote:

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?

glad tol help

--
Don Guillett
SalesAid Software

"Sibbs" wrote in message
...
Got it and it works, thanks for replying Don

"Don Guillett" wrote:

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?