Formula help

[Jeremy Wilkerson]

I need help creating the formula for cell F3. Stating that if cell D3 is as follows:

1-5=0

6-8=3

9-11=4

12-14=6

15-17=8

18-19=10

20-21=12

22+=15

I'm sure its a simple formula but I have no idea of what it is. Thanks for any help

[#2]

Hi Jeremy,

You can do that by setting some Conditional Formatting rules that powered by formulas.

Please find the attached file to see how these rules can be applied.

With regards to the email alerts, I'm sorry! But it's not easy to implement in Excel.

You definitely need to some VBA codes or third-party solutions to do so!

I would suggest you ask this community for that.

Hope that helps