**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.*