hide rows based on font Colour

[annadinesh]

Dear Experts

I want..

I Have a data sheet from Column A to O in which column F to H Contains Dates, between column F to H some Dates are in Red Colour and else are in Black Colour.

and there is button on top of each Column from F to H , I want that when I press a button of a column the entire rows contains Date in Red Colour of that column should Hide.


Please Help

Regards


Dinesh Saha

 

[mumps]

Are the colours entered manually or are they a result of conditional formatting? It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing'
and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[annadinesh]

Are the colours entered manually or are they a result of conditional formatting? It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing'
and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

Result of conditional formatting based on date modify

In column F to H when I click on 1st FS Button the rows with Dates in Black Colour of Column F should show

 

[bebo021999]

Are buttons ActiveX control or Userform control?
Which cells are they linking to?

 

[annadinesh]

Are buttons ActiveX control or Userform control?
Which cells are they linking to?

View attachment 59450

ActiveX control Button, Buttons are Link to That Particular Column, like 1st FS is linked to column F

 

[mumps]

You have posted a picture and pictures are hard to work with. Please post a screen shot using XL2BB or upload your file. What is the conditional formatting formula?