ExcelBanter - View Single Post

wrote:
Click on Tools - Macro - Visual Basic Editor

On the left should be a VBAProject Window. Expand the items listed
until you see Sheet1 (Sheet1). Double Click on Sheet1. A VBA Code
Window will open for Sheet1.

I hope this will help get you started.

Thanks very much that was great just what I needed to do.

next querie if I may
can you make the colour of the text or number in a cell change if a
certain criteria is met ??