Conditional Format almost what I want

  • Thread starter Thread starter Bryan McNally
  • Start date Start date
B

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.
 
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
 
Below is the suggestion I posted in your original thread.

[You should not start a new thread to preserve continuity]
Click to expand...
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
--
Click to expand...
 
You're welcome, Bryan !
Thanks for the feedback.
--
Rgds
Max
xl 97
----------------------------------
Use xdemechanik <at>yahoo<dot>com for email
-----------------------------------------
Bryan McNally said:
Below is the suggestion I posted in your original thread.

[You should not start a new thread to preserve continuity]
Click to expand...
My apologies

Your solution works perfectly. Thank you for your help.
Click to expand...
 
Back
Top