color in cell
I have two cells that are involved. Say H15 has a drop down list of 3 items.
If "purchase order" is selected from the list of 3, I want J15 to turn
orange. Once that cell turns orange then the user knows he/she needs to fill
in that cell (j15) with text or numbers or both. Once they fill in j15 I
want the cell to go back to white. I think I've explained this clearly, if
not let me know.
Thanks,
Tia
|