Conditional formatting not playing ball (2)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
None of those should be interfering with CF. However, you can check that
by opening the file with macros disabled.

Since it works in a new sheet, are you sure you're meeting the condition
(i.e., that E4 contains "Y" with no leading or trailing spaces)?
 
Back
Top