Drisso in Vegas
New Member
- Joined
- Aug 23, 2018
- Messages
- 6
Hi folks, thanks for all the help. Learned a lot about VBA from this group but now I'm trying to create a progress bar in a cell using a conditional formatting Data Bar. What I have is column A with start dates and column B with end dates. I want to show a progress bar for where TODAY() is between the start and end date.
What I've learned so far is to use =(DATEDIF(A1,TODAY(),"d")+1)/(DATEDIF(A1,B1,"d")+1) but only if I have a 3rd column with that formula. The Data Bar shows on top of the percentage in the 3rd column just fine. But what I really want is for the Data Bar to show on top of the end date in column B. I've tried putting that formula in either the minimum and/or maximum values in the formatting rule dialog with the B cell selected but can't seem to figure this one out. Any ideas?
You guys are awesome. Thanks,
Drisso in Vegas
What I've learned so far is to use =(DATEDIF(A1,TODAY(),"d")+1)/(DATEDIF(A1,B1,"d")+1) but only if I have a 3rd column with that formula. The Data Bar shows on top of the percentage in the 3rd column just fine. But what I really want is for the Data Bar to show on top of the end date in column B. I've tried putting that formula in either the minimum and/or maximum values in the formatting rule dialog with the B cell selected but can't seem to figure this one out. Any ideas?
You guys are awesome. Thanks,
Drisso in Vegas
