Question description:
This user has given permission to use the problem statement for this
blog.
Hi there. I'm trying to get a formula that uses an IF statement (or other kind of formula) that will highlight a row if column f has "a" but columns g and h are empty
Solved by M. E. in 10 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
30/07/2018 - 08:27
Hi
User
30/07/2018 - 08:28
Hello :)
Excelchat Expert
30/07/2018 - 08:28
Welcome to Got IT Pro.
Excelchat Expert
30/07/2018 - 08:28
You want to highlight the rows, based on multiple conditons?
Excelchat Expert
30/07/2018 - 08:28
Please provide sample data in preview.
User
30/07/2018 - 08:28
Yes ... here's how my table looks ...
Excelchat Expert
30/07/2018 - 08:28
Sure.
User
30/07/2018 - 08:30
So I'd like the formula to highlight the first row because a return is in progress but the credit hasn't been received
Excelchat Expert
30/07/2018 - 08:31
Ok. So, I need to focus oon F and H columns?
Excelchat Expert
30/07/2018 - 08:31
G and H together will always be empty?
User
30/07/2018 - 08:32
Yed
User
30/07/2018 - 08:32
yes*
User
30/07/2018 - 08:32
So something like highlight if F="a" and G & H are empty
Excelchat Expert
30/07/2018 - 08:33
F is "Y"?
User
30/07/2018 - 08:33
sorry F="Y" in this case ... I use "a" because I have it set up under webdings so it shows up as a checkmark but I'm changing it all to Y
Excelchat Expert
30/07/2018 - 08:34
Ok. I am working on the formula using and conditoin.
Excelchat Expert
30/07/2018 - 08:34
*condition.
User
30/07/2018 - 08:34
Awesome! Thanks!
Excelchat Expert
30/07/2018 - 08:37
=AND($F1="Y",$G1="",$H1="")
User
30/07/2018 - 08:37
Did that work?
User
30/07/2018 - 08:37
Oh wow!! Awesome!! Thank you so much!
Excelchat Expert
30/07/2018 - 08:37
You are welcome.
Excelchat Expert
30/07/2018 - 08:37
Applied over A1:H1000
Excelchat Expert
30/07/2018 - 08:37
You can change columns based on the requirement.
User
30/07/2018 - 08:37
I've been trying to figure out a formula on my own for like 2 weeks!
Excelchat Expert
30/07/2018 - 08:37
Omg.
User
30/07/2018 - 08:37
That's wonderful! THank you so much!
Excelchat Expert
30/07/2018 - 08:38
Good that you have approached here.
Excelchat Expert
30/07/2018 - 08:38
Please do visit Got It Pro. We have 24 * 7 problem solving facility. You can visit any time.
Excelchat Expert
30/07/2018 - 08:38
Have wonderful day ahead. Please end the session and leave valuable feedback.
User
30/07/2018 - 08:38
For sure! I'll be back again for sure!
User
30/07/2018 - 08:38
Thanks!
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.