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.

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.

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.

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.

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.

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.