display a conditional format in a range from another column
 

A6 TO D26 CONTAIN THE NUMBERS 1 TO 45 AND HAVE THE SAME CONDITIONAL FORMATS.
IN COLUMN F6 TO F26 I WANT TO TYPE IN A NUMBER OF 1 TO 45 AND HAVE THE CELL
IN THE RANGE OF A6 TO D26 DISPLAY THE CONDITIONAL FORMAT. IS THIS POSSIABLE?
THANK YOU.

display a conditional format in a range from another column
 

Please get your caps lock key repaired so that you can stop SHOUTING.

If you want any cell in A to D to be conditionally formatted if it has the
same value as column F in that row, then for A6 use CF/ Formula Is/ =A6=$F6,
and copy the format to the rest of the range.
--
David Biddulph

"DAN" wrote in message
...
A6 TO D26 CONTAIN THE NUMBERS 1 TO 45 AND HAVE THE SAME CONDITIONAL
FORMATS.
IN COLUMN F6 TO F26 I WANT TO TYPE IN A NUMBER OF 1 TO 45 AND HAVE THE
CELL
IN THE RANGE OF A6 TO D26 DISPLAY THE CONDITIONAL FORMAT. IS THIS
POSSIABLE?
THANK YOU.

display a conditional format in a range from another column
 

David,
Sorry, fixed the caps lock. My first time here. I think I tried to make my
problem to simple. I'll try again with more information. My range of cells is
A6 to D26 which is 84 cells. The cells are numbered from 1 to 84 and each
cell has the same CF with 3 Conditions. In cells F6 to F26 if I type 5, 36
and 80 to represent the numbers in the range A6 to A26, I want those cells to
display Condition 1. In cells G6 to G26, I want the cells in the range to
display Condition 2 and in H6 to H26, the third condition. I hope this is
explained better and please my being such a novice.
Thanks,
Dan

"David Biddulph" wrote:

Please get your caps lock key repaired so that you can stop SHOUTING.

If you want any cell in A to D to be conditionally formatted if it has the
same value as column F in that row, then for A6 use CF/ Formula Is/ =A6=$F6,
and copy the format to the rest of the range.
--
David Biddulph

"DAN" wrote in message
...
A6 TO D26 CONTAIN THE NUMBERS 1 TO 45 AND HAVE THE SAME CONDITIONAL
FORMATS.
IN COLUMN F6 TO F26 I WANT TO TYPE IN A NUMBER OF 1 TO 45 AND HAVE THE
CELL
IN THE RANGE OF A6 TO D26 DISPLAY THE CONDITIONAL FORMAT. IS THIS
POSSIABLE?
THANK YOU.

display a conditional format in a range from another column
 

No, I've no idea what you want to do.
--
David Biddulph

"DAN" wrote in message
...
David,
Sorry, fixed the caps lock. My first time here. I think I tried to make my
problem to simple. I'll try again with more information. My range of cells
is
A6 to D26 which is 84 cells. The cells are numbered from 1 to 84 and each
cell has the same CF with 3 Conditions. In cells F6 to F26 if I type 5, 36
and 80 to represent the numbers in the range A6 to A26, I want those cells
to
display Condition 1. In cells G6 to G26, I want the cells in the range to
display Condition 2 and in H6 to H26, the third condition. I hope this is
explained better and please my being such a novice.
Thanks,
Dan

"David Biddulph" wrote:

Please get your caps lock key repaired so that you can stop SHOUTING.

If you want any cell in A to D to be conditionally formatted if it has
the
same value as column F in that row, then for A6 use CF/ Formula Is/
=A6=$F6,
and copy the format to the rest of the range.
--
David Biddulph

"DAN" wrote in message
...
A6 TO D26 CONTAIN THE NUMBERS 1 TO 45 AND HAVE THE SAME CONDITIONAL
FORMATS.
IN COLUMN F6 TO F26 I WANT TO TYPE IN A NUMBER OF 1 TO 45 AND HAVE THE
CELL
IN THE RANGE OF A6 TO D26 DISPLAY THE CONDITIONAL FORMAT. IS THIS
POSSIABLE?
THANK YOU.

display a conditional format in a range from another column
 

Sorry David. I'll try one more time to make myself clear. I have a range of
cells from A6 to D26. A6 has the #1 in it, B6 #2, C6 #3, D6 #4 and so on down
to D26 being #84. All these cells have the same CF in which Condition 1 turns
the cell red, Condition 2 turns the cell green and Condition 3 turns the cell
yellow. I need a formula for Condition 1 that would turn any cell in the
range A6 to D26 red if I type any number from 1 to 84 in column F6 to F26. If
I have that formula, I can apply it to Condition 2 and 3.
Thank You

"David Biddulph" wrote:

No, I've no idea what you want to do.
--
David Biddulph

"DAN" wrote in message
...
David,
Sorry, fixed the caps lock. My first time here. I think I tried to make my
problem to simple. I'll try again with more information. My range of cells
is
A6 to D26 which is 84 cells. The cells are numbered from 1 to 84 and each
cell has the same CF with 3 Conditions. In cells F6 to F26 if I type 5, 36
and 80 to represent the numbers in the range A6 to A26, I want those cells
to
display Condition 1. In cells G6 to G26, I want the cells in the range to
display Condition 2 and in H6 to H26, the third condition. I hope this is
explained better and please my being such a novice.
Thanks,
Dan

"David Biddulph" wrote:

Please get your caps lock key repaired so that you can stop SHOUTING.

If you want any cell in A to D to be conditionally formatted if it has
the
same value as column F in that row, then for A6 use CF/ Formula Is/
=A6=$F6,
and copy the format to the rest of the range.
--
David Biddulph

"DAN" wrote in message
...
A6 TO D26 CONTAIN THE NUMBERS 1 TO 45 AND HAVE THE SAME CONDITIONAL
FORMATS.
IN COLUMN F6 TO F26 I WANT TO TYPE IN A NUMBER OF 1 TO 45 AND HAVE THE
CELL
IN THE RANGE OF A6 TO D26 DISPLAY THE CONDITIONAL FORMAT. IS THIS
POSSIABLE?
THANK YOU.

display a conditional format in a range from another column
 

Still not entirely clear, but if you are going to type just one number in
column F6:F26, and you want to colour whichever cell out of the A6:D26 range
has that number, you could use:
CF/ Cell Value Is/ equal to/ =SUM($F$6:$F$26)
--
David Biddulph

"DAN" wrote in message
...
Sorry David. I'll try one more time to make myself clear. I have a range
of
cells from A6 to D26. A6 has the #1 in it, B6 #2, C6 #3, D6 #4 and so on
down
to D26 being #84. All these cells have the same CF in which Condition 1
turns
the cell red, Condition 2 turns the cell green and Condition 3 turns the
cell
yellow. I need a formula for Condition 1 that would turn any cell in the
range A6 to D26 red if I type any number from 1 to 84 in column F6 to F26.
If
I have that formula, I can apply it to Condition 2 and 3.
Thank You

"David Biddulph" wrote:

No, I've no idea what you want to do.
--
David Biddulph

"DAN" wrote in message
...
David,
Sorry, fixed the caps lock. My first time here. I think I tried to make
my
problem to simple. I'll try again with more information. My range of
cells
is
A6 to D26 which is 84 cells. The cells are numbered from 1 to 84 and
each
cell has the same CF with 3 Conditions. In cells F6 to F26 if I type 5,
36
and 80 to represent the numbers in the range A6 to A26, I want those
cells
to
display Condition 1. In cells G6 to G26, I want the cells in the range
to
display Condition 2 and in H6 to H26, the third condition. I hope this
is
explained better and please my being such a novice.
Thanks,
Dan

"David Biddulph" wrote:

Please get your caps lock key repaired so that you can stop SHOUTING.

If you want any cell in A to D to be conditionally formatted if it has
the
same value as column F in that row, then for A6 use CF/ Formula Is/
=A6=$F6,
and copy the format to the rest of the range.
--
David Biddulph

"DAN" wrote in message
...
A6 TO D26 CONTAIN THE NUMBERS 1 TO 45 AND HAVE THE SAME CONDITIONAL
FORMATS.
IN COLUMN F6 TO F26 I WANT TO TYPE IN A NUMBER OF 1 TO 45 AND HAVE
THE
CELL
IN THE RANGE OF A6 TO D26 DISPLAY THE CONDITIONAL FORMAT. IS THIS
POSSIABLE?
THANK YOU.

display a conditional format in a range from another column
 

Thank you. I'm going to try that.

"David Biddulph" wrote:

Still not entirely clear, but if you are going to type just one number in
column F6:F26, and you want to colour whichever cell out of the A6:D26 range
has that number, you could use:
CF/ Cell Value Is/ equal to/ =SUM($F$6:$F$26)
--
David Biddulph

"DAN" wrote in message
...
Sorry David. I'll try one more time to make myself clear. I have a range
of
cells from A6 to D26. A6 has the #1 in it, B6 #2, C6 #3, D6 #4 and so on
down
to D26 being #84. All these cells have the same CF in which Condition 1
turns
the cell red, Condition 2 turns the cell green and Condition 3 turns the
cell
yellow. I need a formula for Condition 1 that would turn any cell in the
range A6 to D26 red if I type any number from 1 to 84 in column F6 to F26.
If
I have that formula, I can apply it to Condition 2 and 3.
Thank You

"David Biddulph" wrote:

No, I've no idea what you want to do.
--
David Biddulph

"DAN" wrote in message
...
David,
Sorry, fixed the caps lock. My first time here. I think I tried to make
my
problem to simple. I'll try again with more information. My range of
cells
is
A6 to D26 which is 84 cells. The cells are numbered from 1 to 84 and
each
cell has the same CF with 3 Conditions. In cells F6 to F26 if I type 5,
36
and 80 to represent the numbers in the range A6 to A26, I want those
cells
to
display Condition 1. In cells G6 to G26, I want the cells in the range
to
display Condition 2 and in H6 to H26, the third condition. I hope this
is
explained better and please my being such a novice.
Thanks,
Dan

"David Biddulph" wrote:

Please get your caps lock key repaired so that you can stop SHOUTING.

If you want any cell in A to D to be conditionally formatted if it has
the
same value as column F in that row, then for A6 use CF/ Formula Is/
=A6=$F6,
and copy the format to the rest of the range.
--
David Biddulph

"DAN" wrote in message
...
A6 TO D26 CONTAIN THE NUMBERS 1 TO 45 AND HAVE THE SAME CONDITIONAL
FORMATS.
IN COLUMN F6 TO F26 I WANT TO TYPE IN A NUMBER OF 1 TO 45 AND HAVE
THE
CELL
IN THE RANGE OF A6 TO D26 DISPLAY THE CONDITIONAL FORMAT. IS THIS
POSSIABLE?
THANK YOU.

display a conditional format in a range from another column
 

Sorry. Didn't work. If I may, I'd like to try one more time. I have 84
storage units and they are numbered 1 to 84 in cells A1 to D21. When I go our
to see which ones have locks on them. I come back with a list of numbers 10,
30, 45, 67 and 84. I go to column F and in F1 type 10 and F2 30, F3 45 and
son on. Each time I type a number, that number in A1 to A21 should format in
red. (Actually I have over 500 units on my worksheet. So if I come back with
40 unit numbers I would like to start putting those numbers down the F column
and as I do they turn red on my worksheet in the A1 to D21 range) Does that
help?
Thanks,
Dan

"David Biddulph" wrote:

Still not entirely clear, but if you are going to type just one number in
column F6:F26, and you want to colour whichever cell out of the A6:D26 range
has that number, you could use:
CF/ Cell Value Is/ equal to/ =SUM($F$6:$F$26)
--
David Biddulph

"DAN" wrote in message
...
Sorry David. I'll try one more time to make myself clear. I have a range
of
cells from A6 to D26. A6 has the #1 in it, B6 #2, C6 #3, D6 #4 and so on
down
to D26 being #84. All these cells have the same CF in which Condition 1
turns
the cell red, Condition 2 turns the cell green and Condition 3 turns the
cell
yellow. I need a formula for Condition 1 that would turn any cell in the
range A6 to D26 red if I type any number from 1 to 84 in column F6 to F26.
If
I have that formula, I can apply it to Condition 2 and 3.
Thank You

"David Biddulph" wrote:

No, I've no idea what you want to do.
--
David Biddulph

"DAN" wrote in message
...
David,
Sorry, fixed the caps lock. My first time here. I think I tried to make
my
problem to simple. I'll try again with more information. My range of
cells
is
A6 to D26 which is 84 cells. The cells are numbered from 1 to 84 and
each
cell has the same CF with 3 Conditions. In cells F6 to F26 if I type 5,
36
and 80 to represent the numbers in the range A6 to A26, I want those
cells
to
display Condition 1. In cells G6 to G26, I want the cells in the range
to
display Condition 2 and in H6 to H26, the third condition. I hope this
is
explained better and please my being such a novice.
Thanks,
Dan

"David Biddulph" wrote:

Please get your caps lock key repaired so that you can stop SHOUTING.

If you want any cell in A to D to be conditionally formatted if it has
the
same value as column F in that row, then for A6 use CF/ Formula Is/
=A6=$F6,
and copy the format to the rest of the range.
--
David Biddulph

"DAN" wrote in message
...
A6 TO D26 CONTAIN THE NUMBERS 1 TO 45 AND HAVE THE SAME CONDITIONAL
FORMATS.
IN COLUMN F6 TO F26 I WANT TO TYPE IN A NUMBER OF 1 TO 45 AND HAVE
THE
CELL
IN THE RANGE OF A6 TO D26 DISPLAY THE CONDITIONAL FORMAT. IS THIS
POSSIABLE?
THANK YOU.

display a conditional format in a range from another column
 

Right. Last attempt, now that you've decided what you do want.
For cell A1, CF/ Formula Is/ =ISNUMBER(MATCH(A1,$F$1:$F$21,0))

Please, if you come back to the group again, decide what your question is
before you ask it. We can usually find an answer for you, but it does rely
on you getting the question right.
--
David Biddulph

"DAN" wrote in message
...
Sorry. Didn't work. If I may, I'd like to try one more time. I have 84
storage units and they are numbered 1 to 84 in cells A1 to D21. When I go
our
to see which ones have locks on them. I come back with a list of numbers
10,
30, 45, 67 and 84. I go to column F and in F1 type 10 and F2 30, F3 45 and
son on. Each time I type a number, that number in A1 to A21 should format
in
red. (Actually I have over 500 units on my worksheet. So if I come back
with
40 unit numbers I would like to start putting those numbers down the F
column
and as I do they turn red on my worksheet in the A1 to D21 range) Does
that
help?
Thanks,
Dan

"David Biddulph" wrote:

Still not entirely clear, but if you are going to type just one number in
column F6:F26, and you want to colour whichever cell out of the A6:D26
range
has that number, you could use:
CF/ Cell Value Is/ equal to/ =SUM($F$6:$F$26)
--
David Biddulph

"DAN" wrote in message
...
Sorry David. I'll try one more time to make myself clear. I have a
range
of
cells from A6 to D26. A6 has the #1 in it, B6 #2, C6 #3, D6 #4 and so
on
down
to D26 being #84. All these cells have the same CF in which Condition 1
turns
the cell red, Condition 2 turns the cell green and Condition 3 turns
the
cell
yellow. I need a formula for Condition 1 that would turn any cell in
the
range A6 to D26 red if I type any number from 1 to 84 in column F6 to
F26.
If
I have that formula, I can apply it to Condition 2 and 3.
Thank You

"David Biddulph" wrote:

No, I've no idea what you want to do.
--
David Biddulph

"DAN" wrote in message
...
David,
Sorry, fixed the caps lock. My first time here. I think I tried to
make
my
problem to simple. I'll try again with more information. My range of
cells
is
A6 to D26 which is 84 cells. The cells are numbered from 1 to 84 and
each
cell has the same CF with 3 Conditions. In cells F6 to F26 if I type
5,
36
and 80 to represent the numbers in the range A6 to A26, I want those
cells
to
display Condition 1. In cells G6 to G26, I want the cells in the
range
to
display Condition 2 and in H6 to H26, the third condition. I hope
this
is
explained better and please my being such a novice.
Thanks,
Dan

"David Biddulph" wrote:

Please get your caps lock key repaired so that you can stop
SHOUTING.

If you want any cell in A to D to be conditionally formatted if it
has
the
same value as column F in that row, then for A6 use CF/ Formula Is/
=A6=$F6,
and copy the format to the rest of the range.
--
David Biddulph

"DAN" wrote in message
...
A6 TO D26 CONTAIN THE NUMBERS 1 TO 45 AND HAVE THE SAME
CONDITIONAL
FORMATS.
IN COLUMN F6 TO F26 I WANT TO TYPE IN A NUMBER OF 1 TO 45 AND
HAVE
THE
CELL
IN THE RANGE OF A6 TO D26 DISPLAY THE CONDITIONAL FORMAT. IS THIS
POSSIABLE?
THANK YOU.

display a conditional format in a range from another column
 

tSorry again for the trouble bur formula does not work. May I mail you my
worksheet which is much eaiser to understand?
Dan

"David Biddulph" wrote:

Right. Last attempt, now that you've decided what you do want.
For cell A1, CF/ Formula Is/ =ISNUMBER(MATCH(A1,$F$1:$F$21,0))

Please, if you come back to the group again, decide what your question is
before you ask it. We can usually find an answer for you, but it does rely
on you getting the question right.
--
David Biddulph

"DAN" wrote in message
...
Sorry. Didn't work. If I may, I'd like to try one more time. I have 84
storage units and they are numbered 1 to 84 in cells A1 to D21. When I go
our
to see which ones have locks on them. I come back with a list of numbers
10,
30, 45, 67 and 84. I go to column F and in F1 type 10 and F2 30, F3 45 and
son on. Each time I type a number, that number in A1 to A21 should format
in
red. (Actually I have over 500 units on my worksheet. So if I come back
with
40 unit numbers I would like to start putting those numbers down the F
column
and as I do they turn red on my worksheet in the A1 to D21 range) Does
that
help?
Thanks,
Dan

"David Biddulph" wrote:

Still not entirely clear, but if you are going to type just one number in
column F6:F26, and you want to colour whichever cell out of the A6:D26
range
has that number, you could use:
CF/ Cell Value Is/ equal to/ =SUM($F$6:$F$26)
--
David Biddulph

"DAN" wrote in message
...
Sorry David. I'll try one more time to make myself clear. I have a
range
of
cells from A6 to D26. A6 has the #1 in it, B6 #2, C6 #3, D6 #4 and so
on
down
to D26 being #84. All these cells have the same CF in which Condition 1
turns
the cell red, Condition 2 turns the cell green and Condition 3 turns
the
cell
yellow. I need a formula for Condition 1 that would turn any cell in
the
range A6 to D26 red if I type any number from 1 to 84 in column F6 to
F26.
If
I have that formula, I can apply it to Condition 2 and 3.
Thank You

"David Biddulph" wrote:

No, I've no idea what you want to do.
--
David Biddulph

"DAN" wrote in message
...
David,
Sorry, fixed the caps lock. My first time here. I think I tried to
make
my
problem to simple. I'll try again with more information. My range of
cells
is
A6 to D26 which is 84 cells. The cells are numbered from 1 to 84 and
each
cell has the same CF with 3 Conditions. In cells F6 to F26 if I type
5,
36
and 80 to represent the numbers in the range A6 to A26, I want those
cells
to
display Condition 1. In cells G6 to G26, I want the cells in the
range
to
display Condition 2 and in H6 to H26, the third condition. I hope
this
is
explained better and please my being such a novice.
Thanks,
Dan

"David Biddulph" wrote:

Please get your caps lock key repaired so that you can stop
SHOUTING.

If you want any cell in A to D to be conditionally formatted if it
has
the
same value as column F in that row, then for A6 use CF/ Formula Is/
=A6=$F6,
and copy the format to the rest of the range.
--
David Biddulph

"DAN" wrote in message
...
A6 TO D26 CONTAIN THE NUMBERS 1 TO 45 AND HAVE THE SAME
CONDITIONAL
FORMATS.
IN COLUMN F6 TO F26 I WANT TO TYPE IN A NUMBER OF 1 TO 45 AND
HAVE
THE
CELL
IN THE RANGE OF A6 TO D26 DISPLAY THE CONDITIONAL FORMAT. IS THIS
POSSIABLE?
THANK YOU.

display a conditional format in a range from another column
 

Nevermind. I got it to work and it's perfect. Thank you very much.
Dan

"David Biddulph" wrote:

Right. Last attempt, now that you've decided what you do want.
For cell A1, CF/ Formula Is/ =ISNUMBER(MATCH(A1,$F$1:$F$21,0))

Please, if you come back to the group again, decide what your question is
before you ask it. We can usually find an answer for you, but it does rely
on you getting the question right.
--
David Biddulph

"DAN" wrote in message
...
Sorry. Didn't work. If I may, I'd like to try one more time. I have 84
storage units and they are numbered 1 to 84 in cells A1 to D21. When I go
our
to see which ones have locks on them. I come back with a list of numbers
10,
30, 45, 67 and 84. I go to column F and in F1 type 10 and F2 30, F3 45 and
son on. Each time I type a number, that number in A1 to A21 should format
in
red. (Actually I have over 500 units on my worksheet. So if I come back
with
40 unit numbers I would like to start putting those numbers down the F
column
and as I do they turn red on my worksheet in the A1 to D21 range) Does
that
help?
Thanks,
Dan

"David Biddulph" wrote:

Still not entirely clear, but if you are going to type just one number in
column F6:F26, and you want to colour whichever cell out of the A6:D26
range
has that number, you could use:
CF/ Cell Value Is/ equal to/ =SUM($F$6:$F$26)
--
David Biddulph

"DAN" wrote in message
...
Sorry David. I'll try one more time to make myself clear. I have a
range
of
cells from A6 to D26. A6 has the #1 in it, B6 #2, C6 #3, D6 #4 and so
on
down
to D26 being #84. All these cells have the same CF in which Condition 1
turns
the cell red, Condition 2 turns the cell green and Condition 3 turns
the
cell
yellow. I need a formula for Condition 1 that would turn any cell in
the
range A6 to D26 red if I type any number from 1 to 84 in column F6 to
F26.
If
I have that formula, I can apply it to Condition 2 and 3.
Thank You

"David Biddulph" wrote:

No, I've no idea what you want to do.
--
David Biddulph

"DAN" wrote in message
...
David,
Sorry, fixed the caps lock. My first time here. I think I tried to
make
my
problem to simple. I'll try again with more information. My range of
cells
is
A6 to D26 which is 84 cells. The cells are numbered from 1 to 84 and
each
cell has the same CF with 3 Conditions. In cells F6 to F26 if I type
5,
36
and 80 to represent the numbers in the range A6 to A26, I want those
cells
to
display Condition 1. In cells G6 to G26, I want the cells in the
range
to
display Condition 2 and in H6 to H26, the third condition. I hope
this
is
explained better and please my being such a novice.
Thanks,
Dan

"David Biddulph" wrote:

Please get your caps lock key repaired so that you can stop
SHOUTING.

If you want any cell in A to D to be conditionally formatted if it
has
the
same value as column F in that row, then for A6 use CF/ Formula Is/
=A6=$F6,
and copy the format to the rest of the range.
--
David Biddulph

"DAN" wrote in message
...
A6 TO D26 CONTAIN THE NUMBERS 1 TO 45 AND HAVE THE SAME
CONDITIONAL
FORMATS.
IN COLUMN F6 TO F26 I WANT TO TYPE IN A NUMBER OF 1 TO 45 AND
HAVE
THE
CELL
IN THE RANGE OF A6 TO D26 DISPLAY THE CONDITIONAL FORMAT. IS THIS
POSSIABLE?
THANK YOU.