Hey all,
I asked a question similar to this the other day, but have changed my approach and wanted to get some input.
Based on the date ranges in the table below, is it possible to use conditional formatting, or VBA, to color cells a solid color. Even better, if possible, can I use a gradient color?
Thank you!!
I asked a question similar to this the other day, but have changed my approach and wanted to get some input.
Based on the date ranges in the table below, is it possible to use conditional formatting, or VBA, to color cells a solid color. Even better, if possible, can I use a gradient color?
Book4 | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |||
1 | Project | Project Start Date | Commissioning | UAT | Shadowing | Target Project Completion Date | Feb-2022 | Mar-2022 | Apr-2022 | May-2022 | Jun-2022 | Jul-2022 | Aug-2022 | Sep-2022 | Oct-2022 | Nov-2022 | Dec-2022 | Jan-2023 | ||
2 | Software Enhancement | 1/1/2022 | 2/1/2022 | 3/1/2022 | 3/15/2022 | 3/29/2022 | ||||||||||||||
Sheet1 |
Thank you!!