dynamically formatting cells help!!!

[anonymowho]

Hi this is what I am trying to do. I have a testing tool written in excel which gives the number of errors and asks the developers to enter an explanation of this error.

item1______12_______This error occurred because blah blah...

in this above row, there are 12 errors indicated for item 1. I want to show the cell with the number 12 as red if no explanation for the error is entered, i want it to show green if an explanation has been provided, and no color fill if the number is 0 which means no errors.

I am trying to do this with conditional formatting but I am having no luck. Can someone tell me of a better way to handle this.

 

[xenou]

I have this worksheet:

Book1
	A	B	C	D	E
1	ITEM#	Errors	Reason
2	Item1	1
3	Item2	2	UserError
4	Item3	3	Dogatemynotes
5	Item4	0
6
Sheet2

My Conditional Format In Cell B2 Is:
Condition 1 --
Cell Value | Is Equal To | 0
Format Font to Regular

Condition 2 --
Formula Is | =OR(ISBLANK(OFFSET(B2,0,1)),OFFSET(B2,0,1)="")
Format Font to Bold Red

Condition 3 --
Formula Is | =NOT(ISBLANK(OFFSET(B2,0,1)))
Format Font to Bold Green

The Format in Cell B2 can be copied down to the other cells in Column B.
Hopefully I have the order of precedence correct. I like to use the offsets so that inserting rows/columns doesn't screw up the formulas.