Changing colors

kenpcli

Board Regular
Joined
Oct 24, 2017
Messages
129
How do I get VBA to look down a column of dates and it the date is less that the date in cell A1 it fills the cell color with red and if it is equal to or 30 days out it colors the cell yellow?
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,095,746
Messages
5,446,253
Members
405,392
Latest member
Steveoaktree1977

This Week's Hot Topics

Top