If 80 in column A and date = today...
Hello,
I have a table with 200 to 500 entries, where 1 entries = 1 row.
I want a macro that will check for the number 80 in column A. If
not 80 then nothing.
If 80 in column A then for this row:
Check the information in column E : if empty or contains a date
later than today then nothing.
If column E contains a date earlier or equal to today then:
1. change the 80 for a 0 in column A
2. change whatever is in column B for also a 0
3. change the color of the row (from column A to F) in pale blue.
Then thats it.
Can anyone help me?
Thank you!
Souriane
|