Some help in refernceing some cells

  • Thread starter Thread starter kylekoopman
  • Start date Start date
K

kylekoopman

Hi there,

I need help.
I have a long list of numbers, and in each cell next to each number,
want to display a color if that number appeared in the last 42 numbers

So if it did - color "Green"
and if not - color " RED"

PLEASE HELP!! Anybody!!
Thanks
K
 
Hi KK

What does "last 42 numbers" mean.. Do you mean number that has appeared
in previous 42 rows above the current row in a unbroken sequence...
Give an example if possible.....

Thanks
Karthik Bhat
 
It means this.....

Ok in Column "A" I have numbers in each cell all the way down to cell
100
Now in column "B" I want to display a color (green or red) depending on
if the number next to that cell in column A appeared in the last 42
numbers of column A.

example.

Cell A64 displays a 6
Next to it in Cell B64 I want it to display GREEN because in the 42
cells above A64, there were two 6's.

Another example.

Cell A49 displays a 12
Next to it in cell B49 I want it to display RED because the number 12
has not appeared in the last 42 cells above A49.

So basically I just want colum B referencing the last 42 cells from
column A, and displaying GREEN if the number beside it in column A
appeared, or RED for VICE VERSA.

Hope that helps.
Thanks
KK
 
May be like this :

Fill this in cell B:43
=IF(NOT(ISNA(VLOOKUP(A43,INDIRECT("A"&ROW()-42&":A"&ROW()-1),1,FALSE))),"TRU
E","FALSE")

then copy down to the last row you want, so we've "TRUE" and "FALSE" value
in colom B

and then use conditional formating
Format|Conditional Formatting

condition 1 : Cell Value Is | Equal To | ="TRUE"
change the format to GREEN

condition 2 : Cell Value Is | Equal To | ="FALSE"
change the format to RED

may be .....





"kylekoopman" <[email protected]>
wrote in message
news:[email protected]...
 
Back
Top