is it possible to change the color of the whole row, hide the row, or apply 'strikeout' to the whole row (row a to row m) based on the value of column F?
is it possible to change the color of the whole row, hide the row, or apply 'strikeout' to the whole row (row a to row m) based on the value of column F?
i worked this out but the format painter seems to copy colours as well, can i stop this ?
Look at conditional formatting instead
http://www.contextures.com/xlCondFormat01.html
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks