Formatting with two criteria

[raccoon588]

I would like to be able to format K6 with a fill of red if G6 has text selected from a drop down AND K6 is empty. If G6 is empty id like the K6 to be left alone.

i tried

=AND(G6="*",K6="")

in the conditional formatting section but it is not working.

 

[Joe4]

Try:

[COLOR=#333333]=AND(G6<>"",K6="")[/COLOR]

 

[Fluff]

Try
=AND(G6<>"",K6="")

 

[raccoon588]

This works, thank you

 

[Joe4]

You are welcome.
Glad we could help.