Bonnie Janes
New Member
- Joined
- Apr 27, 2017
- Messages
- 38
Hi All, if anyone can help me with the problems below, and within this document; Excel Formulas_COUNTIF & Conditional Formatting Problems.xlsx I would be eternally grateful! 
Problem 1
Services completed early/late – COUNTIF?
ROW 6
I need a formula that counts from the column below dates that are before or after the MONTH of the column. I wrote one that should have worked, but it didn’t, so had to count manually. Need this to be automatic… ideas?
Problem 2
Last Serviced Date – CONDITIONAL FORMATTING FORMULA
COLUMN E
I need a formula that checks the frequency in months (Column C&D), against the date in Last Serviced Column (E) to check if it’s OVERDUE. i.e. if it must be serviced every 6 months and the last serviced date is greater than 6 months then the date cell in column E highlights RED.
Problem 3
Conditional formatting WILL NOT colour numbers on the cusp 89% figure or 50% figure yellow!
Should be
90-100 = Green
51 to 89 = Yellow
50 or less = Red
ROWS 4 & 7

Problem 1
Services completed early/late – COUNTIF?
ROW 6
I need a formula that counts from the column below dates that are before or after the MONTH of the column. I wrote one that should have worked, but it didn’t, so had to count manually. Need this to be automatic… ideas?
Problem 2
Last Serviced Date – CONDITIONAL FORMATTING FORMULA
COLUMN E
I need a formula that checks the frequency in months (Column C&D), against the date in Last Serviced Column (E) to check if it’s OVERDUE. i.e. if it must be serviced every 6 months and the last serviced date is greater than 6 months then the date cell in column E highlights RED.
Problem 3
Conditional formatting WILL NOT colour numbers on the cusp 89% figure or 50% figure yellow!
Should be
90-100 = Green
51 to 89 = Yellow
50 or less = Red
ROWS 4 & 7