How to change text color dep.on the value of another cell.
Closed
noxat
Posts
1
Registration date
Friday January 16, 2015
Status
Member
Last seen
January 16, 2015
-
Jan 16, 2015 at 02:13 AM
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Jan 20, 2015 at 11:41 PM
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Jan 20, 2015 at 11:41 PM
Related:
- How to change text color dep.on the value of another cell.
- Notepad++ change background color - Guide
- How to change free fire google account to another google account - Guide
- How to change number of best friends on snapchat - Guide
- Html text color - Guide
- How to change language in kmplayer - Guide
1 response
ArashMan
Posts
38
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
Jan 20, 2015 at 11:41 PM
Jan 20, 2015 at 11:41 PM
Dear noxat
first you should select the firs name in the list then go to Home\conditional formatting\new rules and select the last option like the picture
then you should type this function
=or(the debt cell>0)
then you go to format/fill tab and select red color
after you press OK you should go to applies to and select all names
the attached file will help. i hope that is what you want
https://upload7.ir/404/vfont/not.html
first you should select the firs name in the list then go to Home\conditional formatting\new rules and select the last option like the picture
then you should type this function
=or(the debt cell>0)
then you go to format/fill tab and select red color
after you press OK you should go to applies to and select all names
the attached file will help. i hope that is what you want
https://upload7.ir/404/vfont/not.html
