New to macros..I am trying to colour format cells using macro as manual formatting it's increasing the file size.
Want to see if can build a macro that colours the cell range basis of value obtained from current date and format the list of data with respective colours till the last row data is filled.
Column E data is 'date' which I am using to obtain value in cells H:I:J:K BY Adding days I have to complete an activity. I want to use current date to determine when activity is pending for action (though the dates show this but need to highlight as my staff tend to miss on that)
.
If value in column H:K is <= than today() colour = Red
If value in column H:K is = today()+1day colour = Yellow
If value in column H:K is = today()+2days colour = Green
Not sure how to go abt that.
Want to see if can build a macro that colours the cell range basis of value obtained from current date and format the list of data with respective colours till the last row data is filled.
Column E data is 'date' which I am using to obtain value in cells H:I:J:K BY Adding days I have to complete an activity. I want to use current date to determine when activity is pending for action (though the dates show this but need to highlight as my staff tend to miss on that)

If value in column H:K is <= than today() colour = Red
If value in column H:K is = today()+1day colour = Yellow
If value in column H:K is = today()+2days colour = Green
Not sure how to go abt that.
Last edited: