Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting not playing ball | Excel Discussion (Misc queries) | |||
Bingo Ball | Excel Discussion (Misc queries) | |||
You guys are on the ball in here ... | Excel Worksheet Functions | |||
Ezcel crystal ball | Setting up and Configuration of Excel | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |