Conditional Format almost what I want

[Bryan McNally]

The conditional formats does exactly what I want for one cell, but, I have
6 cells I want to put numbers in that check the same grid of numbers. How
do I do this.

 

[Max]

Below is the suggestion I posted in your original thread.

[You should not start a new thread to preserve continuity]

---------------------------------------
Assume your master set of 6 numbers is in A1:F1
and your grid of numbers to be checked is in say A2:F100

Select A2

Click Format > Conditional Format

Under Condition1, make the settings:
---------------------------------------------
Formula Is: | =COUNTIF($A$1:$F$1,A2)>0
Click Format button > Patterns tab > Green? > OK
Click OK at the main dialog

Now to copy the conditional formatting .. :

With the formatted cell A2 selected,

Double-click on the Format Painter icon ("brush")
[cursor will turn into "brush"]

Click to select [i.e. "paint" over] the grid A2:F100

Press Esc to revert the cursor to normal

 

[Bryan McNally]

Below is the suggestion I posted in your original thread.

[You should not start a new thread to preserve continuity]

My apologies

Your solution works perfectly. Thank you for your help.

Assume your master set of 6 numbers is in A1:F1
and your grid of numbers to be checked is in say A2:F100

Select A2

Click Format > Conditional Format

Under Condition1, make the settings:
---------------------------------------------
Formula Is: | =COUNTIF($A$1:$F$1,A2)>0
Click Format button > Patterns tab > Green? > OK
Click OK at the main dialog

Now to copy the conditional formatting .. :

With the formatted cell A2 selected,

Double-click on the Format Painter icon ("brush")
[cursor will turn into "brush"]

Click to select [i.e. "paint" over] the grid A2:F100

Press Esc to revert the cursor to normal
--

 

[Max]

You're welcome, Bryan !
Thanks for the feedback.
--
Rgds
Max
xl 97
----------------------------------
Use xdemechanik <at>yahoo<dot>com for email
-----------------------------------------

Below is the suggestion I posted in your original thread.

[You should not start a new thread to preserve continuity]

My apologies

Your solution works perfectly. Thank you for your help.