LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cathy
 
Posts: n/a
Default Change Cell Color Based on IF Statement

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change event on specific cell rather than worksheet frendabrenda1 Excel Discussion (Misc queries) 10 September 21st 06 03:37 AM
change info in 1 cell, prompts you for another redb Excel Discussion (Misc queries) 2 September 1st 05 11:56 AM
copy combobox - cell link to change automatically Bojana Excel Worksheet Functions 1 June 8th 05 02:35 PM
Change cell color dependin on date ... T. Denford Excel Worksheet Functions 4 April 13th 05 01:59 AM
How do I change color of active cell in Excel lfletcher Excel Discussion (Misc queries) 4 April 4th 05 06:29 PM


All times are GMT +1. The time now is 04:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"