wolf.stalker
07-11-2011, 10:44 AM
Hey all and thanks for your input!
here is where i am having issues. i will have 20 rows of data. in all that data, column H = start date / time, and column I will = my end date / time. i need to setup some type of conditional formatting based on this.
for example, (if H <= today() <= I) then we want to fill that cell a color (in middle of event) <vbGreen>
(if today() > I) then we want to fill that a different color (event passed) <vbRed>
(if today() +2 > H and today() <= I) (event coming up in 2 days) then shade yet a third color. <vbYellow>
let me know if you have any ideas that might work :yes
here is where i am having issues. i will have 20 rows of data. in all that data, column H = start date / time, and column I will = my end date / time. i need to setup some type of conditional formatting based on this.
for example, (if H <= today() <= I) then we want to fill that cell a color (in middle of event) <vbGreen>
(if today() > I) then we want to fill that a different color (event passed) <vbRed>
(if today() +2 > H and today() <= I) (event coming up in 2 days) then shade yet a third color. <vbYellow>
let me know if you have any ideas that might work :yes