Excel - IF Function Problem - Expert Solution

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

I am trying to make a chart that turns a week range red if nothing is entered in the range. If something is entered then I would like it to turn green. Please Help
Solved by E. U. in 43 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 14/06/2018 - 07:04
Hello and welcome to Got it! :)
User 14/06/2018 - 07:04
Excelchat Expert 14/06/2018 - 07:05
If I understand your concern correctly, you want to change the color of a range in a chart when depending on whether it has content or none. Is this correct? :)
User 14/06/2018 - 07:05
User 14/06/2018 - 07:06
We'd need to change the color of the whole range if one of the cells has any content
Excelchat Expert 14/06/2018 - 07:07
I see! Okay then. Perhaps it is best if we can demonstrate a solution on a sample problem here. Or if it's okay with you, can you perhaps provide your working file for us to look at? Thanks! :)
User 14/06/2018 - 07:07
We currently have nothing in a working file, but I can give an example
Excelchat Expert 14/06/2018 - 07:07
Oh sure, that would be great! :)
User 14/06/2018 - 07:09
So with that R in there I would like all the cells to the right of John Smith's name from B2 through H2 turn green. Since the second week has nothing I'd like all the cells from I2 through O2 to turn red
User 14/06/2018 - 07:10
Does that make sense? I'd like to do the whole month as well
Excelchat Expert 14/06/2018 - 07:10
Oh! I thought we're actually going to work on with charts in here. Like, bar charts and pie charts lol :D
User 14/06/2018 - 07:10
Oh my bad, sorry!
Excelchat Expert 14/06/2018 - 07:11
It's okay. Let's just look at then your concern as of the moment. :)
User 14/06/2018 - 07:11
Thank you!
Excelchat Expert 14/06/2018 - 07:13
Okay, I believe I understood your concern in here. You want to shade the week green if it has something on it, while red if it has nothing on it. Okay, let me work on a solution for this one and update you the soonest. :)
User 14/06/2018 - 07:13
Perfect, thank you
User 14/06/2018 - 07:18
I have 6 minutes left in the chat, any luck?
Excelchat Expert 14/06/2018 - 07:19
Oh, we could actually extend for free when timer hits around 2 minutes. I'll need to think hard on this one since it's pretty tricky, but I believe it is doable. :)
User 14/06/2018 - 07:19
Thank you so much!
User 14/06/2018 - 07:19
You're the best
Excelchat Expert 14/06/2018 - 07:37
Nearly done. :)
User 14/06/2018 - 07:37
Thank you!
User 14/06/2018 - 07:40
Will it extend again if we run out of time?
Excelchat Expert 14/06/2018 - 07:40
Yup. :)
User 14/06/2018 - 07:40
Excelchat Expert 14/06/2018 - 07:41
That'll be the last free extension though, since we're allowed only twice. :)
User 14/06/2018 - 07:41
Well hopefully we won't need another haha
Excelchat Expert 14/06/2018 - 07:42
Already done. :)
User 14/06/2018 - 07:42
Excelchat Expert 14/06/2018 - 07:42
Basically, it's a play of conditional formatting using a formula. :)
User 14/06/2018 - 07:43
That's what we figured, but couldn't get it to work haha
Excelchat Expert 14/06/2018 - 07:43
The formula is equal ot the one in row 3. :)
Excelchat Expert 14/06/2018 - 07:43
Oh nice! Glad to be of help then. :)
User 14/06/2018 - 07:43
Oh yeah we never would have gotten that, thank you so much!
Excelchat Expert 14/06/2018 - 07:43
Nice! If all is good now, please do end the session via the button on the upper right of your screen (sorry, can't do it from our end). Please do leave a good feedback upon your exit. Thanks so much and have a nice day! :)
Excelchat Expert 14/06/2018 - 07:44
Btw, you can download a copy of the document preview by going to File > Download as > Microsoft Excel (.xlsx). The formulas will be downloaded as well. :)
User 14/06/2018 - 07:45
Perfect, thanks so much. So if we need to enter more names would we just go every other line down?
Excelchat Expert 14/06/2018 - 07:46
Yes, you can just drag down the cells :)
User 14/06/2018 - 07:46
Oh cool, so if we just put it at the bottom it works?
Excelchat Expert 14/06/2018 - 07:47
Oh, you could just delete the TRUE/FALSE row since it's just an indication that the conditional formatting is working. :)
Excelchat Expert 14/06/2018 - 07:47
Basically, the same formula used on them is the one that is entered in the conditional formatting of the cells. :)
User 14/06/2018 - 07:47
Oh great, thanks so much!
User 14/06/2018 - 07:48
I'll end the session now
User 14/06/2018 - 07:48
You were a ton of help

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc