Select the whole 6x24 array, assume it is A1:F24, if you select starting
with A1
then A1 will be the active cell. Now assume the cells in the 6x1 are H1:H6
With A1 as the active cell put this in the formula is box
=COUNTIF($H$1:$H$6,A1)>0
adapt to fit the real ranges
--
Regards,
Peo Sjoblom
"Wingnut" <(E-Mail Removed)> wrote in message
news:3fa9f1e6$0$3788$(E-Mail Removed)...
> Thanks for that, but maybe I've missed something. (I'm still a relative
> novice at using a lot of Excel's functionality).
>
> I'm trying to apply the condition to a selection of cells (6x24); any
cells
> which have a value present in the array (6x1) will display differently to
> the others.
>
> I tried your suggestion on an individual cell, (which works), but I need
the
> same condition to apply to all of the 144 cells selected and I'm having
> difficulty specifying this.
>
> Pardon my ignorance.
>
> Thanks,
> Steve
>
> "Peo Sjoblom" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > Format>conditional formatting, formula is
> >
> > =COUNTIF(MyRange,MyCell)>0
> >
> > --
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> >
> > "Wingnut" <(E-Mail Removed)> wrote in message
> > news:3fa8eb14$0$3789$(E-Mail Removed)...
> > Is anyone able to tell me please how I can conditionally format a cell
> based
> > on whether the cell value matches a value in a specified group of values
> > (ie. an array) ?
> >
> > All suggestions welcome.
> >
> > Thanks,
> > Steve
> >
> >
>
>
|
Similar Threads
