Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide columns based on format
Hello. I have managed (using a formula in the conditional formating) to put
some color on every cell in a column which content is different to the one of the first row. Now I'd like to hide the columns that do not have yellow cells. Is that possible? Thank you!! :o) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide columns based on format
Hi,
Hiding or summing in VB using CF colours isn't easy because the colour of the cell is different from it's colorindex so it may be easier to hide the cells based upon the condition itself rather then the colour in the cell but to do that you'll have to be more specific. Have a look here http://www.cpearson.com/excel/CFColors.htm Mike "Taghne" wrote: Hello. I have managed (using a formula in the conditional formating) to put some color on every cell in a column which content is different to the one of the first row. Now I'd like to hide the columns that do not have yellow cells. Is that possible? Thank you!! :o) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Columns based on a cell value | Excel Worksheet Functions | |||
macro to hide # of columns based on value | Excel Programming | |||
Hide Columns Based on Condition | Excel Programming | |||
Hide Columns Based on Condition | Excel Programming | |||
hide columns based on header macro | Excel Programming |