Formatting Cells based on previous cells valu [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I want to be able to highlight a cell based on the previous cells value.
Example: if cell D1 is 450 and cell E1 is 480 then I want that cell to turn red. I need to have the whole row to do this? How can this be done?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
your question is not clear. You say based on previous value. what is this calculation based on. Is it hard coded value of 450 etc. You need to explain more

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!