Help with conditional format problem

[pedro-egoli]

Part of my spreadsheet

Excel Workbook
	F	G	H	I
2	452	380	385	448
3	30	31	30	15
4	Apr	May	Jun	Jul
5	452	380	385	216.7742
SUMMARY PV PRODUCTION USAGE

I have conditional format as follows
Condition 1
=(F5="") and dragged across
Format is for No colour
Condition 2
=ISNUMBER(FIND("G",numForm)) and dragged across
Format is for Light green if condition met

Cell Format is set at General

What I want to do is just have result in row 5 show only 2 decimal places rather than the 4 that started to happen in I5.

Any suggestions appreciated.

Pedro

 

[VoG]

In I5

=IF(I3=0,"",ROUND(I3*I2/I1,2))

 

[pedro-egoli]

Thanks for that.
Sorry I did not fully explain my problem.

I had tried formatting cell as Number but this had the effect of overwriting the green format .

Tried your suggestion and it too cleared the green format.

So what I want is two decimal places and if there is a number in cell for it to be shaded light green. other wise remain clear.
Pedro

 

[pedro-egoli]

Solved problem.

Cell format changed to Number
Condioional Format condition 2 changed to

=(F5>1) and dragged across

Thanks to all who may have tried to assist
Pedro