How to change text color dep.on the value of another cell.
Closed
noxat
ArashMan
- Posts
- 1
- Registration date
- Friday January 16, 2015
- Status
- Member
- Last seen
- January 16, 2015
ArashMan
- Posts
- 41
- Registration date
- Monday December 15, 2014
- Status
- Member
- Last seen
- February 18, 2015
Related:
- How to change text color dep.on the value of another cell.
- How to change taskbar color windows 7 - Guide
- Notepad change background color - Guide
- How to change text color based on value in excel ✓ - Forum - Excel
- Change crosshair color - Guide
- How to change text color in textbox in html - Guide
1 reply
ArashMan
Jan 20, 2015 at 11:41 PM
- Posts
- 41
- Registration date
- Monday December 15, 2014
- Status
- Member
- Last seen
- February 18, 2015
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