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.