Hi I need/want a VBA for conditional formatting that triggers every time the Sheet is Selected
column F is all dates from “H5:H30000”, I need if possible, to have.
I have added as normal conditional formatting but as the data is copied and pasted into the list the formatting is wiped
Thanks Dave
column F is all dates from “H5:H30000”, I need if possible, to have.
- All blank cells to be White
- Any cell that is older than XXXX date to go red
- Any Cell equal to or less than XXXXX date to stay Whist
I have added as normal conditional formatting but as the data is copied and pasted into the list the formatting is wiped
Thanks Dave