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
[Uploaded an Excel file]
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.
