color in cell
Try this:
In Excel 2007
Select cell J15
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format
Enter this formula in the box below:
=AND(H15="purchase order",J15="")
Click the Format button
Select the Fill tab
Select the desired color
OK out
In Excel versions 2003 and earlier
Select cell J15
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=AND(H15="purchase order",J15="")
Click the Format button
Select the Patterns tab
Select the desired color
OK out
--
Biff
Microsoft Excel MVP
"Tia" wrote in message
...
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
|