display a conditional format in a range from another column

  • Thread starter Thread starter DAN
  • Start date Start date
D

DAN

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,
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
 
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
 
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)
 
Thank you. I'm going to try that.

David Biddulph said:
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)
Click to expand...
 
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
 
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.
 
tSorry again for the trouble bur formula does not work. May I mail you my
worksheet which is much eaiser to understand?
Dan
 
Back
Top