Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting??
Hi,
I need to create either a macro or condition formating so that i can change a field from its defualt to green when a job is done, and back to its defualt when deleted. I've had a go at conditional formating and can change it to green(using a simple macro(recorded changing the fill colour)) and can change it back to its defualt by adding a conditional formating parameter. the problem is that when i enter a new value into this field it automatically turns to green, and i need it to stay as defualt until completed. any ideas??? regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |