Negative nubers turn to black in Conditional Formating

[johnny1r]

Hello and thanks for looking at my question! I am using Excel 2016 and am trying to get Conditional Formatting to give negative numbers and only negative numbers to show in red type. Numbers on Worksheet are formatted red for negative.
A1 B1 C1 D1 E1 F1 G1
10 5 -10 -5 -3 5 3
There are 2 conditions to each cell starting in B1, 1) B1 < A1 should get Red background, Black Type. 2) B1 > A1 you should get Green background and Black Type. Font color is set as automatic. The result in B1 is, Red background/ Black Type. C1 result should be red/red, D1 result should be green background/red type and so on. What I get is negative numbers in black. If I format in conditional formatting, numbers with negative numbers in red, the result is black number with no minus sign.
My eyes aren't what they used to be and it's easier to see red numbers than a minus sign for me.
I am an Excel retired home user and have been trying now for days and hope there is a solution, Thank You. John

 

[jtakw]

Thank Rick.

Regarding OP's CF:

According to your description, you Already have the cells formatted so that negatives are shown in red.

For the Background Fill, you already have the proper formulas, you just needed to put them in CF.

Book1
	A	B	C	D	E	F	G	H
1	10.00	5.00	10.00	5.00	3.00	5.00	3.00	<- Cell formatted red font for negative #s
2	10.00	5.00	-10.00	-5.00	-3.00	5.00	3.00	<- Actual Values of row 1 w/o cell format
3
4		Red Background
5		TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
6
7		Green Background
8		FALSE	FALSE	TRUE	TRUE	TRUE	FALSE
Sheet177

Cell Formulas
Range	Formula
B5	=B1
B8	=B1>A1

Select B1:G1, Conditional Formatting, New Rule, Use a formula....,enter the formula as shown in my sample B5, click Format, select Fill, select RED.
Repeat for Green using the formula in B8 as shown in my sample.

Let us know if you need further help.

 

[johnny1r]

I am truly sorry if I am Confusing you. In my original post I tried to show there were 2 conditions, the cell shade color, and the number color. Example.... Cell 1= -0.10 (RED Number), Cell 2=-0.05 (RED Number). Cell 2 is conditionally formatted to be shaded Green if greater value than cell 1, or to be shaded Red if less value than Cell 1. Cell 2 should be shaded GREEN with Red Number. The Problem is the number turns black when the Conditional format is applied. Not sure what I am doing wrong. Sorry for delay but I type very slow.

 

[jtakw]

That's what I have, I repost the screenshot:

Book1
	A	B	C	D	E	F	G	H
1	10.00	5.00	10.00	5.00	3.00	5.00	3.00	<- Cell formatted red font for negative #s
2	10.00	5.00	-10.00	-5.00	-3.00	5.00	3.00	<- Actual Values of row 1 w/o cell format
3
4		Red Background
5		TRUE	TRUE	FALSE	FALSE	FALSE	TRUE
6
7		Green Background
8		FALSE	FALSE	TRUE	TRUE	TRUE	FALSE
Sheet177

Cell Formulas
Range	Formula
B5	=B1
B8	=B1>A1

For the negative numbers to be Red "Font", just select B1:G1, right click, format cells, number, choose 2nd option from list.

 

[johnny1r]

Yes Thank You!!! I will give it a try ! John

 

[johnny1r]

Perfect, Works GREAT!!!! Thank You, Thank You!!

 

[jtakw]

You're welcome, happy you got it working for you.