Conditional Formatting everytime the cell value is change

Hi guys! Just need some help. Is there a formula that I can use in the conditional formatting so that every time I change something with the cell, it's background will turn red?

Thanks!

The closest I can think of would be to highlight the last cell that was updated. The formula would look something like this (this would be the conditional formatting for A1):

Formula:

Please Login or Register  to view this content.

This is untested and I'm assuming it works based off what I read in the help file for the CELL function.

excel.JPG Hi! Thanks for your response. The purpose is just to alert us that the cell is change. Either thru conditional formatting or data validation. I've attach the pic. If something is change on the yellow cell/s , Is it possible to display an alert or something? Do you think it's possible? Thanks!

Thanks Spitzerpl ! You rocks!

Hi there Spitzerpl ! Thanks for your idea earlier. I tried the formula that you mentioned . It actually worked on the first cell. But as I do the CF on the other cells, the first cell that I formatted changes its color also. Your help is highly appreciated. I've attached the file and what I need is for the cells in yellow to change to red if the data in that particular cell is modified. Is it possible?

Thanks Sixthsense ! It also works but even when changes are made on the other cells, it still prompts.

Wow! Thanks a lot six sense! you're the man!