Previous Topic Next Topic

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?

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
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses