Sharad,
Thanks for your help so far.
Unfortunately the example file that I am working on is at work and I can
only get back to it on Monday. But I'll let you & the NG know of the outcome
of your suggestions as soon as possible.
Regards
J_J

"Sharad" wrote in message
...
Well J_J then it might be possible that the Yellow colour you are
talking about is not actually Yellow (6) but some other shade.
Now cut and pase following code in to a module.

Sub WhatColour()
MsgBox Selection.Interior.ColorIndex
End Sub

Now select your one of the Yellow Cells,
Click on Tools Menu- Macro - Macros - Select 'WhatColour' to run it.

It will show the colourindex of the selected cell.

In the code given by me / Bob earlier change the colourindex accordinly.

Sharad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!