I am at a loss here. I have attached a simplified working copy of my form.
I have searched every
where I can find but keep coming up with sheet based formulas, I am looking for a VBA fix for this.
selects the name of the person, and it populates the textbox with the associated date.
When the textbox is
changed, I am *trying* to determine 3-4 conditions and color them accordingly.
I have thought to use conditional
formatting, but it has to be based off of the selection from the Combobox, so that won't work.
1. If the checkbox
is selected (automatically does based off of reading the cell color) then it will change the interior color to the bright
green color (this works)
2. If the date is within a week from now, then color it yellow.. this doesn't work for
3. If the date is older than the current date, then color it red.. this doesn't work either
the date is greater than the week out date, then leave it white.. this works, but only because the others don't I assume.
If anyone can help me out on how to compare dates that would be great.
Please excuse the messy code.