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
Based on the values in cells b77 b88 ✓ - Excel Forum
How to see previous downloads on safari - Guide
Conditional formatting if cell contains text ✓ - Excel Forum
Excel conditional formatting based on date - Guide
Based on the values in cells b77 b81 what function can automatically return the value in cell c77 ✓ - Excel Forum

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

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

Fill adjacent cell with number from text answer

Name Values

Excel function question

Similar discussions

Subscribe To Our Newsletter!