coloring

Hello, I got a macro button which adds month sheets for a specific year that is entered in an inputbox. The following code unsuccessfully attempts to fill all working days with a pink colour if they match a range of cells that represent the holidays (and include blank cells). Is there a way to...

Hi all. I am trying to create a dynamic gantt chart in excel through VBA. I am currently struggling with the offsetting the coloring part. Below, you can see my code which I have produced so far. I am having problems with the final bit. I hope someone will be able to help me. BR Hans. Sub...

hi all, is possible: i am on C1, if the value of A1 is equal to 50 then coloring the cell A1 with yellow color? something like this: =if(A1=50,colorcell(yellow), A1-B1) thanks

I have FEW TABELS in my sheet except this boxes i need rest for the cells need to be Grey color (if cells have value it should be not change) is it possible?

Hello All, I have a table which has conditional Formatting. The coloring is based upon formula. I have generated Pie Chart from it. I need the Pie chart sectors to have color that comes from the conditional formatting of the table. I'm using Excel 2010. Kindly suggest.