Change cell background based on multiple cells
Thanks!
Now I'm having another problem with it.
This is going to be part of a macro, and the number of rows may change
with each worksheet.
When I apply the formatting to the entire column, which includes a
header row, the highlighed cells are shifted up one row because the
header is included.
So my question is, how can I exclude the header and have the correct
cells highlighted?
|