Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
Make text color match cell color with macro? | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) |