Conditional formating

[JTAVERAS]

Hi, I have a file where I have columns H through T. On colum T I have either a positve $ amount or a negateive $ amount. I would like to setup a conditional formating to have the cells on H through T automatically Turn Green or Red on that row based on whether its positive or negative. I have 150 rows. Thank you in advance.

 

[DanteAmor]

Try:

varios 09nov2024.xlsm
	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Head1	Head2	Head3	Head4	Head5	Head6	Head7	Head8	Head9	Head10	Head11	Head12	Head13
2	data	data	data	data	data	data	data	data	data	data	data	data	0
3	data	data	data	data	data	data	data	data	data	data	data	data	-2
4	data	data	data	data	data	data	data	data	data	data	data	data	1
5	data	data	data	data	data	data	data	data	data	data	data	data	2
6	data	data	data	data	data	data	data	data	data	data	data	data	5
7	data	data	data	data	data	data	data	data	data	data	data	data	-4
8	data	data	data	data	data	data	data	data	data	data	data	data	3
Hoja2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H2:T150	Expression	=$T2<0	text	NO
H2:T150	Expression	=$T2>0	text	NO

If you want to include 0 as a green color, then change this formula $T2>0 to $T2>=0

 

[JTAVERAS]

Thank you