Conditional format, cell format

[alliswell]

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

 

[Peter_SSs]

i want this negative number in red color and balance in black ..

If the cell contains a formula, which yours does, you cannot do that.

.. or both in red

25 02 23.xlsm
	H	I	J
1	83	40	-43 Balance
CF Red

Cell Formulas
Range	Formula
J1	J1	=IF(I1="","",IF(I1=0,"PAID",IF(I1="-","PENDING",IF(I1<H1,I1-H1&" Balance",""))))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J1	Expression	=LEFT(J1,1)="-"	text	NO

 

[alliswell]

If the cell contains a formula, which yours does, you cannot do that.

25 02 23.xlsm
	H	I	J
1	83	40	-43 Balance
CF Red

Cell Formulas
Range	Formula
J1	J1	=IF(I1="","",IF(I1=0,"PAID",IF(I1="-","PENDING",IF(I1<H1,I1-H1&" Balance",""))))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J1	Expression	=LEFT(J1,1)="-"	text	NO

Thanks peter its working.
But a minor issue. Its not effecting in my j1:j500.
In conditional format i put like this =left(j1:j500,1)="-"
But not working

 

[Peter_SSs]

In conditional format i put like this =left(j1:j500,1)="-"

That is not the correct way.

1. Remove all the conditional formatting from col J
2. Select J1:J500
3. In Conditional formatting put the formula =LEFT(J1,1)="-"

Excel will automatically adjust the formula for all the other rows

 

[alliswell]

That is not the correct way.

1. Remove all the conditional formatting from col J
2. Select J1:J500
3. In Conditional formatting put the formula =LEFT(J1,1)="-"

Excel will automatically adjust the formula for all the other rows

Ok. Thanks thanks a lot bro

 

[Peter_SSs]

You are welcome.