Formatting Cells based on previous cells valu

Closed

Busta - Apr 21, 2010 at 12:41 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 21, 2010 at 12:51 PM

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?

Formatting Cells based on previous cells valu
Excel macro to create new sheet based on value in cells - Guide
Conditional formatting if cell contains text - Excel Forum
Clear only the formatting from the selected cell (leaving the content) - Guide
How would you change all cells containing the word pass to green - Excel Forum
How to see previous downloads on safari - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 21, 2010 at 12:51 PM

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

Similar discussions

help me to add particular cells

Fill adjacent cell with number from text answer

Excel function question

Return Seq Values Until Blank value then return different set of seq values

Clear cell contents based on value of another cell range using VBA

Similar discussions

Subscribe To Our Newsletter!