View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_7_] John C[_7_] is offline
external usenet poster
 
Posts: 1
Default Conditional Format Cells to Change Color when used in formula of aDIFFERENT CELL

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