Easy when you know how - thanks Pogue!

I was trying to be too clever and using an extra entry in Conditional
Formatting...

Thanks again to all who replied - it is much appreciated.

Kind regards,
-=pp=-

"Pogue" wrote in message
...
Easily solved. Our formula had assumed the cell would be blank - it
instead
carries a 0 value. Change to:
=IF(H20=0,"",IF(H20<80%,"FAIL","PASS"))

"Pheasant Plucker®" wrote:

Great!

Thanks to all who replied - this ng is the greatest and I am learning
all
the time! :-)

One last question though...sorry.

If none of the results have not yet been filled in then cell H20
displays 0%

This obviously now displays FAIL in black, bolded text in a Red cell -
technically this is correct because H20 is below 80% but as no data has
been
entered yet technically it cannot be a Fail ;^)

How do I prevent the FAIL appearing in this red cell if H20 is
displaying 0%
because no data has been entered yet?

Ideally I would like to have no data in the cell but have it coloured
Yellow
to indicate that it is an important cell but no data has yet been
entered
into the spreadsheet.

If it helps the cells involved are all formatted as Percentage and their
formulas are as follows;

H20=H17+H19

H19 has no formula currently as it is 'under development' - maybe a
question
for another time!

H17=SUM(C17:G17)/100

C17=IF(C12="","",AVERAGEA(C12:C16))
D17=IF(D12="","",AVERAGEA(D12:D16))
etc.

Thanks again,
-=pp=-


"David Biddulph" <david(dot)biddulph(at)baesystems.com wrote in message
...
"Pheasant Plucker®" wrote in message
...
Hi there,

I have a spreadsheet where the percentage score will indicate a Pass
or
Fail.

Is there a way that I can automatically input the words Pass or Fail
depending on what the percentage score actually is?

For example;

If cell H20 indicates 80% or above then input the word Pass (text
coloured
black and bold) in cell I22 coloured green?

If cell H20 indicates less than 80% then input the word Fail (text
coloured
black and bold) in cell I22 coloured Red?

If the black text in a coloured box is too difficult to achieve then
just
the word Pass in Green or Fail in Red would suffice.

I22 to have no colour if no result present.

Does this even make sense and if it does is there an easy way to
achieve
this?

In I22 put the formula =IF(H20="","",IF(H20<80%,"FAIL","PASS"))
Then in I22 select Format/ Conditional Formatting
Set the condition Cell Value is equal to FAIL, use the pattern tab for
your
red background and the Font tab to make your text bold.
Use the Add button to add another condition & set up your PASS to
green &
bold in the same way.
--
David Biddulph