Im using conditional formating to highlight a number of cells in a colum if they are 180 days past the date entered.For example I'm using =(A1+180)<today() to determine this. Now i need to count the highlighted cells. I tried using countif with the appropriate range and the formula I used to for the conditional formatting but it didnt work. Please help!
Last edited by miter69; 07-14-2009 at 01:17 PM.
Hi,
Try this in B1 copied down
=(A1+180)<TODAY()
Then to count
=COUNTIF(B1:B20,TRUE)
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
If you didn't want a helper column (B1:B20), you could possibly just use:
=COUNTIF(A1:A20,"<"&TODAY()-180)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks