Conditional formatting / value in array

  • Thread starter Thread starter Wingnut
  • Start date Start date
W

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
 
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
 
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
 
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
 
Back
Top