Hi there,
The test:
will always return a value of False, because the cell interior colour was set to 16777215 just a few steps before.
See if the attached workbook does what you need. It uses the following code (at first sight it appears more complicated, but it's better structured and lends itself to use with other worksheets, data columns etc.):
The highlighted values can be altered to suit your own requirements. Structuring the code in the above way means that if layout/highlighting requirements change, the associated code changes need to be made in one location only.
Hope this helps - please let me know how you get on.
Regards,
Greg M
Bookmarks