# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need a formula that shows: if D2 is 0-305 and D4 is 311-330, cell D4 will be a specific color.
Solved by C. H. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 02/05/2018 - 12:59
Hi there!
Excelchat Expert 02/05/2018 - 01:00
I believe this can be solved using a formula based conditional format. Are you able to share your file that you're working with?
User 02/05/2018 - 01:00
no, havent set it up yet
Excelchat Expert 02/05/2018 - 01:01
Are you using Excel or Google Sheets?
User 02/05/2018 - 01:01
excel
Excelchat Expert 02/05/2018 - 01:01
OK perfect.. I can model the conditional formatting formula and send you the file so you have it for reference for when you build your file.. would that work?
User 02/05/2018 - 01:02
I am setting up a sheet to determine academic growth. Ok that will be great
Excelchat Expert 02/05/2018 - 01:02
Sounds awesome... ok one moment
User 02/05/2018 - 01:02
ok
Excelchat Expert 02/05/2018 - 01:03
have you used conditional formatting before?
User 02/05/2018 - 01:03
yes
Excelchat Expert 02/05/2018 - 01:03
Ok fantastic
Excelchat Expert 02/05/2018 - 01:07
Ok check out this file
Excelchat Expert 02/05/2018 - 01:07
User 02/05/2018 - 01:11
I think this may do it! I will see what I come up with. Thank you
Excelchat Expert 02/05/2018 - 01:11
Awesome!!
Excelchat Expert 02/05/2018 - 01:11
So glad to help. Please don't hesitate to ping us with a new session if you need further assistance.
Excelchat Expert 02/05/2018 - 01:12
Have a great day ~
User 02/05/2018 - 01:12
You too, Will do!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.