# Excel - IF Function Problem - Expert Solution

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.

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.