alliswell
Board Regular
- Joined
- Mar 16, 2020
- Messages
- 217
- Office Version
- 2007
- Platform
- Windows
- Mobile
Hi everybody
H I J K
1 83 40
2
3
in j1 i am using this formula
=if(i1="","",if(i1=0,"PAID",IF(I1="-","PENDING",IF(i1<h1,i1-h1&" Balance",""))))
now, j1 gets result -43 Balance. so i want this negative number in red color and balance in black and or both in red. i tried with conditional format and cell format but color didnt changed to red.
thanks and regards
H I J K
1 83 40
2
3
in j1 i am using this formula
=if(i1="","",if(i1=0,"PAID",IF(I1="-","PENDING",IF(i1<h1,i1-h1&" Balance",""))))
now, j1 gets result -43 Balance. so i want this negative number in red color and balance in black and or both in red. i tried with conditional format and cell format but color didnt changed to red.
thanks and regards