Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
Conditional Format Titles | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Conditional format | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions |