Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting not playing ball (2)
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)? In article , Jock wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting not playing ball (2)
Select cells A4:G97 with cell A4 as the active cell
then enter your formula. You might also check that the cells in the E column are actually single character or perhaps use =TRIM($E4)="Y" More information on Conditional Formatting http://www.mvps.org/dmcritchie/excel/condfmt.htm -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Jock" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting not playing ball (2)
Thanks guys. For some reason, CF gives me grief EVERY time! lol
-- Traa Dy Liooar Jock "David McRitchie" wrote: Select cells A4:G97 with cell A4 as the active cell then enter your formula. You might also check that the cells in the E column are actually single character or perhaps use =TRIM($E4)="Y" More information on Conditional Formatting http://www.mvps.org/dmcritchie/excel/condfmt.htm -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Jock" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |