View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jock Jock is offline
external usenet poster
 
Posts: 440
Default Conditional formatting not playing ball (2)

Once more with feeling...
Applied this to range A4:G97
=$E4="Y" formatted as strikethrough, the idea being to strikethrough the
whole row (up to G anyway).
It doesn't work, and I can't figure out why.
I inserted a new worksheet and formatted it the same, and this worked fine!
There are three pieces of code chundering away in the background of this
worksheet;
1 to colour rows depending on what number is placed in cells in 'C',
2 to open a Word doc, and
3 to sort the sheet by ascending number on column 'C'.
Could any of these codes be stopping the conditional formatting working?
Thanks


--
Traa Dy Liooar

Jock