Jana

I have to do this also...here's what I do....

I usually hilight one cell, then on the tool bar select Format, Conditional
Formatting, for Condition 1 select "Cell Value is" from the dropdown list,
select "less than", enter 1. Click on Format, in the color selection, select
red.

Then I copy the cell, hilight all cells that applies and paste format.

Hope this helps.


"Jana" wrote:

I am trying to show the percentage difference between two numbers and also
show the overage in red....Help!