Multi conditional formatting in excel

[paolfili]

Hello.
Is there any way (VBA?) to obtain a multi- conditional formatting in
an excel region?
i.e. I can red-color cell on condition#1 (region's cell < -1).
I want add green-color cells on condition#2 (region's cell > 1)
Is it possible in some way?
Thanks

Paolo

 

[VoG]

Try like this

Excel Workbook
	A
1	-2
2	0
3	-1
4	2
5	0
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =A1>1	Abc
A1	2. / Formula is =A1<-1	Abc

 

[paolfili]

Thanks.
Silly questions.

Try like this

Excel Workbook
	A
1	-2
2	0
3	-1
4	2
5	0
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =A1>1	Abc
A1	2. / Formula is =A1<-1	Abc