Is there a function to make a cell auto-highlighted if another cell>0

Is there a function to make a cell auto-highlighted if another cell has a value greather than 0 entered into it?

The cell to be highlighted (cell H12) contains;

=((H9/H10)*H11)

The cell that will activate the highlighting (cell H9) is used by the spreadsheet-user to enter a numerical figure to determine a scenario.

Any help is mucho appreciated!

Hi

Try.

Select Cell H12
Select Format > Conditional Formatting
With Dropdown select Greater than and enter 0 in the next field.

This link should help if you get stuck

http://www.cpearson.com/excel/cformatting.htm


VBA noob