Compare a cell whit itself (conditional formating)
Closed
ArashMan
Posts
38
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
-
Jan 18, 2015 at 01:01 AM
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Jan 20, 2015 at 11:18 PM
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Jan 20, 2015 at 11:18 PM
Hello,
i want to know is that possible to compare a value of a cell with itself.
for example i enter "10" in cell B2
tomorrow i want to change it to "15" and i want to know is there any way that this cell goes red because 15 is bigger than 10
and it goes green if i enter any value less than 10
thanks for your useful responds.
i want to know is that possible to compare a value of a cell with itself.
for example i enter "10" in cell B2
tomorrow i want to change it to "15" and i want to know is there any way that this cell goes red because 15 is bigger than 10
and it goes green if i enter any value less than 10
thanks for your useful responds.
Related:
- Compare a cell whit itself (conditional formating)
- Beyond compare - Download - File management
- Clear only the formatting from the selected cell (leaving the content) - Guide
- If cell contains date then return value ✓ - Office Software Forum
- Based on the cell values in cells b77 ✓ - Excel Forum
- Count if cell contains number - Excel Forum
1 response
ArashMan
Posts
38
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
Jan 20, 2015 at 11:18 PM
Jan 20, 2015 at 11:18 PM
guys i need your helps please.
i will appreciate your answers
thanks
i will appreciate your answers
thanks