Conditional Formatting Help :-)

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

See http://www.xldynamic.com/source/xld.CF.html#due

somehow i expected something different, but this will work.

thank you!