| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional cell formating
I have a spreadsheet to track RMA cases. I have one cell when marked
indicates the case is open. The other cell indicates the case has been closed. Can I format the cells to so that when I have the case marked as open the the closed cell will be blank and vice versa? A1 B1 C1 Company Name Open Closed Joe company x When B1 is marked with an "X" C1 should be blank and vice versa. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| excel conditional formating decimal fractions | Excel Worksheet Functions | |||
| Conditional formating -identify blank cell | Excel Worksheet Functions | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formating for a blank cell | Excel Discussion (Misc queries) | |||
Threaded Mode
