IF data question

[NyxieMoon]

Is there a formula where:

There is a drop down menu in column A, let's say the menu is Earrings, Necklace, and Rings. And depending on what the user selects, (Rings) I want column B to turn red. Once they enter in their ring size in column B (not a selection, they type it in) I want that cell to turn back white.

Is that possible? I can get create something that turns column B red depending on column A's answer, however it says TRUE and the formula is in column B and I want an answer there.

Any help would be great and much appreciated! Thank you!

 

[Joe4]

Welcome to the Board!

To change colors like that, you would use Conditional Formatting.
So, if you had wanted to highlight cell B1 red if A1 is "Rings" and B1 is blank, then you would use this Conditional Formatting formula:

=AND(A1="Rings",B1="")

and then select the red color format option.

 

[NyxieMoon]

Hi! That works brilliantly! Thank you very much!

 

[Joe4]

You are welcome!

Glad I was able to help.