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
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
- Jan 20, 2015 at 11:41 PM
Hello, I have 2 questions:
1. I'd like to change one's name color to red if that is in debt.
2. want to count a. all names (number of all people); b. people in debt - those names in red
Help me
Thanks

1 reply

ArashMan
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
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
0