Conditional format - formula

[Alphazulu]

Good morning -

I'd like to use conditional formatting to highlight cell G2 red when "Other" is selected from a drop down in Cell F2.

The red highlight is to notify the user additional detail is required in G2 when "Other" is selected in F2. I'll plan on applying the same rules to all Cells in Column G.

Also, if possible once text is entered in G2 I'd like the red highlight to go away.

Any ideas?

 

[VoG]

Try

=AND(G2<>"",F2="Other")

 

[laughingdevil]

Try

=AND(G2<>"",F2="Other")

Wouldn't it be

=AND(G2="",F2="Other")?

 

[VoG]

Oops! Yes, of course. Thanks

 

[Alphazulu]

Now it works.....Thank you both for replying!

 

[laughingdevil]

Oops! Yes, of course. Thanks

No worries

 

[Alphazulu]

Any chance someone could help update the following formula to highlight Cell G2 Red (conditional formatting) when EITHER "Other" or "Pricing" is selected from a drop down in Cell F2?

=AND(G2="",F2="Other")

Thanks

 

[VoG]

Try

=AND(G2="",OR(F2="Other",F2="Pricing"))

 

[Alphazulu]

Bingo....thanks