Idea about Shading Cells

[martin0010]

Hi, I need to know how to shade a cell if it matches one of 30 specific numbers. Can`t seem to do it with conditional formatting (too many numbers). Any Ideas??

Many thanks
Martin

[Bryan Hessey]

Hi, I need to know how to shade a cell if it matches one of 30 specific numbers. Can`t seem to do it with conditional formatting (too many numbers). Any Ideas??

Many thanks
Martin

Hi,

The non-VB code 'easy' way would be with a helper cell (say Z1) with a formula something like

=IF(SUMPRODUCT(--({1;2;4;6;8;90;99}=A1))>0,"k","")

and then Conditionally Format A1 based on Z1="k"

Optionally adjust one of the many VB solutions available in this (or th Miscellaneous) Forum

hth
---