Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to make a correction to several cells in a spreadsheet and I would
like to know which cells were changed afterwards. So, I would like to create an IF statement to make the changes, and I would like either the font color or cell fill color to change so that I know which cells were altered. Something like: IF(A2 < 65 , A2 +12 and A2 Font= Red, A2 - 16 and A2 Font = Blue) I don't think a conditional format will work as an audit trail in this case. Is there a way to build the logic into the IF statement? Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change event on specific cell rather than worksheet | Excel Discussion (Misc queries) | |||
change info in 1 cell, prompts you for another | Excel Discussion (Misc queries) | |||
copy combobox - cell link to change automatically | Excel Worksheet Functions | |||
Change cell color dependin on date ... | Excel Worksheet Functions | |||
How do I change color of active cell in Excel | Excel Discussion (Misc queries) |