Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is it possible to change a cell color through conditional formatting (or some other method) to have a cell color change when it's cell's location is used in a formula of a different cell.
A quick example: Cell A2 would change to red if a formula was typed into cell A3 that referenced the cell A2. I am doing a lot of Boolean logic AND / OR statements and would like to keep track of the bits that I have already used. I already use the "Trace Precedents" tool in Excel, but think this color changing would help greatly if possible. Thanks! John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional format color is set correct, yet color will not change | Excel Worksheet Functions | |||
Change cell colour on formula result change, no conditional format | Excel Programming | |||
Conditional format: change row color based on cell value | Excel Discussion (Misc queries) | |||
Conditional to change cell color by Selecting Cells | Excel Discussion (Misc queries) | |||
Conditional Format: Expired dates wanting cell to change color | Excel Discussion (Misc queries) |