Using Conditional Formatting based on several different reference cells

[RStal24]

I am trying to create a spreadsheet that allows me to track how well our business is following its projected costs/profits on certain projects.

My spreadsheet is nearly complete, but it is large and cumbersome, so I want to create a key at the top that turns a cell red if there is a problem in any of perhaps ten references cells.

i.e. I want cell A2 to turn red if I have a negative number in any any of the following cells E8, G8, I8, K8, M8, O8, C81, F81, D106, F106, H106. The same condition <0 applies to all of these cells.

Is this possible, and how would I go about creating it?

I really appreciate anyone's help.

 

[jim may]

What version Excel are you?

 

[RStal24]

2010

 

[jim may]

Create a new sample Workbook like the below table in the exact same cell range..

I used small range, example, but select cell A2, goto Cond/Formating.. Formula and in box enter:

=OR($C$4<0,$D$5<0,$C$7<0,$D$8<0,$C$10<0,$D$11<0)

Select Format.. Fill, Red

Close

Now Change Cell D8 to a negative value,

Excel Workbook
	A	B	C	D	E
2
3		39	6	23	58
4		52	8	9	53
5		26	23	28	42
6		35	59	7	94
7		77	2	8	94
8		16	31	1	47
9		96	56	73	54
10		33	52	40	10
11		19	66	5	39
Sheet1

Excel 2007