Ok, I have two issues.
First, I didn't realize I could do conditional formatting based on a true formula. What I would like is a formula that highlights dates in E:E a certain color, say red, if they are within range B3 to B3+15 and the information in T:T is FALSE.
Second issue... a tad more complicated.
I have a formula that counts the number of times a serial number shows up on a report, but my formula doesn't count a formula twice if it appears. So I need some help, if anyone would be so kind
a b c d e
1 S/N date CMPLTD start: 1/1/2011
2 100 1/2/2011 TRUE end: 2/1/2011
3 101 1/4/2011 TRUE
4 102 1/6/2011 TRUE
5 103 1/6/2011 TRUE
6 104 1/7/2011 FALSE
7 105 1/8/2011 FALSE
8 100 1/10/2011 TRUE
9 106 2/1/2011 FALSE
What I'm trying to achieve is to count the number of cells in column A if the date in columb B is within the criteria of E1 and E2, and the CMPLTD column is TRUE.
The current formula I use only counts the unique values:
CSE
Thanks!
Bookmarks