Fill in cell color depending on formula

I need a formula for if column G3 says received and F3 says yes
then H3 fills in Green or if G3 says received and F3 says no then H3 fills in Red.
Who is Participating?
NBVCConnect With a Mentor Commented:
You need conditional formatting.

Select H3, go to Home|Conditional Formatting|New Rule

Then "Use a formula to determine which cells to format"

enter formula =AND($G3="Received",$F3="Yes")

click format and choose Green from the Fill tab.

Click Ok,

Then click New Rule, and repeat above with

=AND($G3="Received",$F3="No") and Format with Red from Fill tab.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.