Please Reply

[missprogrammer]

Within my workbook i have serveral worksheets that have several columns
and the last the colums on each worksheet i want to color red where it is null what should i do. Please Reply

 

[RickSpr]

If you're using Excel 2000, all you have to do is use Conditional Formatting to format the last column.

If you're using an earlier version, Conditional Formatting is not available. You'll have to write code that loops through each worksheet and each cell in the last column looking for empty cells; format each cell red if empty, or your default color if not.

You'll also have to choose some event that invokes the code. Rick Sprague