Conditional formatting / value in array

[Wingnut]

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

 

[Peo Sjoblom]

Format>conditional formatting, formula is

=COUNTIF(MyRange,MyCell)>0

--

Regards,

Peo Sjoblom


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

 

[Wingnut]

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]

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