software

I'll never get the hang of this...:-(

I had a similar problem recently that was solved in this ng (Thanks Dave:-)
but have a related problem that I thought I could solve by applying the same
logic - alas it was not meant to be for me :-(

I want to use Conditional Formatting to achieve the following - if the value
in Cell H15 is lower than 75 then colour it red.

This I can achieve quite easily by using the following in Condition 1:

If Cell Value is Less Than 75 then Format Pattern Red

However I do not want the cell to be coloured Red if there is no value in
there at all - I only want to be able to turn the cell red after I have
input the value and that value is less than 75

Obviously I need to test for input in H15 prior to checking if it is below
75 and invoking the colour change if it is - leaving no change if it has no
value or is 75 or above.

I have tried using a COUNTA but cannot seem to get it to work.

Can some kind soul help me out on this one (again) please?

--
Thanks amp; regards,
-pp-
Hi!

Just a little tweak is all you need.

Use the Formula Is option
Formula is: =AND(ISNUMBER(H15),H15lt;75)

Biff

quot;Pheasant Plucker®quot; gt; wrote in message
...
gt; I'll never get the hang of this...:-(
gt;
gt; I had a similar problem recently that was solved in this ng (Thanks
gt; Dave:-)
gt; but have a related problem that I thought I could solve by applying the
gt; same
gt; logic - alas it was not meant to be for me :-(
gt;
gt; I want to use Conditional Formatting to achieve the following - if the
gt; value
gt; in Cell H15 is lower than 75 then colour it red.
gt;
gt; This I can achieve quite easily by using the following in Condition 1:
gt;
gt; If Cell Value is Less Than 75 then Format Pattern Red
gt;
gt; However I do not want the cell to be coloured Red if there is no value in
gt; there at all - I only want to be able to turn the cell red after I have
gt; input the value and that value is less than 75
gt;
gt; Obviously I need to test for input in H15 prior to checking if it is below
gt; 75 and invoking the colour change if it is - leaving no change if it has
gt; no
gt; value or is 75 or above.
gt;
gt; I have tried using a COUNTA but cannot seem to get it to work.
gt;
gt; Can some kind soul help me out on this one (again) please?
gt;
gt; --
gt; Thanks amp; regards,
gt; -pp-
gt;
gt;
Change the format condition to quot;Formua Isquot; rather than quot;Cell Value Isquot;
and enter this formula;

=AND(H15gt;0,H15lt;75)

You can still have the same red background format.

Hope this helps.

PeteThanks for the quick reply Biff.

Did I miss something here or was my original post not as clear as it should
have been...

I tried your formula but even though at rest the cell is clear (good) if I
enter 75 or above the Cell is still red (bad)?

I only want it to change to Red if below 75 - if 75 or above I do not want
to colour it - just leave it as a normal cell...

Thanks for your patience!

Regards,
-=pp=-quot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; Just a little tweak is all you need.
gt;
gt; Use the Formula Is option
gt; Formula is: =AND(ISNUMBER(H15),H15lt;75)
gt;
gt; Biff
gt;
gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt; ...
gt; gt; I'll never get the hang of this...:-(
gt; gt;
gt; gt; I had a similar problem recently that was solved in this ng (Thanks
gt; gt; Dave:-)
gt; gt; but have a related problem that I thought I could solve by applying the
gt; gt; same
gt; gt; logic - alas it was not meant to be for me :-(
gt; gt;
gt; gt; I want to use Conditional Formatting to achieve the following - if the
gt; gt; value
gt; gt; in Cell H15 is lower than 75 then colour it red.
gt; gt;
gt; gt; This I can achieve quite easily by using the following in Condition 1:
gt; gt;
gt; gt; If Cell Value is Less Than 75 then Format Pattern Red
gt; gt;
gt; gt; However I do not want the cell to be coloured Red if there is no value
in
gt; gt; there at all - I only want to be able to turn the cell red after I have
gt; gt; input the value and that value is less than 75
gt; gt;
gt; gt; Obviously I need to test for input in H15 prior to checking if it is
below
gt; gt; 75 and invoking the colour change if it is - leaving no change if it has
gt; gt; no
gt; gt; value or is 75 or above.
gt; gt;
gt; gt; I have tried using a COUNTA but cannot seem to get it to work.
gt; gt;
gt; gt; Can some kind soul help me out on this one (again) please?
gt; gt;
gt; gt; --
gt; gt; Thanks amp; regards,
gt; gt; -pp-
gt; gt;
gt; gt;
gt;
gt;
Thanks for the quick reply Pete,

I must have missed something here as both suggestions from yourself amp; Biff
did not work for me...

I tried your formula but even though at rest the cell is clear (good) if I
enter 75 or above the Cell is still red (bad)?

I only want it to change to Red if below 75 - if 75 or above I do not want
to colour it - just leave it as a normal cell...

Thanks for your patience also!

Regards,
-=pp=-quot;Pete_UKquot; gt; wrote in message ups.com...
gt; Change the format condition to quot;Formua Isquot; rather than quot;Cell Value Isquot;
gt; and enter this formula;
gt;
gt; =AND(H15gt;0,H15lt;75)
gt;
gt; You can still have the same red background format.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
Hmmm.....

Do you have any other conditions? Condition 2 and/or condition 3?

If this is the ONLY condition it should work!

Biff

quot;Pheasant Plucker®quot; gt; wrote in message
...
gt; Thanks for the quick reply Biff.
gt;
gt; Did I miss something here or was my original post not as clear as it
gt; should
gt; have been...
gt;
gt; I tried your formula but even though at rest the cell is clear (good) if I
gt; enter 75 or above the Cell is still red (bad)?
gt;
gt; I only want it to change to Red if below 75 - if 75 or above I do not want
gt; to colour it - just leave it as a normal cell...
gt;
gt; Thanks for your patience!
gt;
gt; Regards,
gt; -=pp=-
gt;
gt;
gt; quot;Biffquot; gt; wrote in message
gt; ...
gt;gt; Hi!
gt;gt;
gt;gt; Just a little tweak is all you need.
gt;gt;
gt;gt; Use the Formula Is option
gt;gt; Formula is: =AND(ISNUMBER(H15),H15lt;75)
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; I'll never get the hang of this...:-(
gt;gt; gt;
gt;gt; gt; I had a similar problem recently that was solved in this ng (Thanks
gt;gt; gt; Dave:-)
gt;gt; gt; but have a related problem that I thought I could solve by applying the
gt;gt; gt; same
gt;gt; gt; logic - alas it was not meant to be for me :-(
gt;gt; gt;
gt;gt; gt; I want to use Conditional Formatting to achieve the following - if the
gt;gt; gt; value
gt;gt; gt; in Cell H15 is lower than 75 then colour it red.
gt;gt; gt;
gt;gt; gt; This I can achieve quite easily by using the following in Condition 1:
gt;gt; gt;
gt;gt; gt; If Cell Value is Less Than 75 then Format Pattern Red
gt;gt; gt;
gt;gt; gt; However I do not want the cell to be coloured Red if there is no value
gt; in
gt;gt; gt; there at all - I only want to be able to turn the cell red after I have
gt;gt; gt; input the value and that value is less than 75
gt;gt; gt;
gt;gt; gt; Obviously I need to test for input in H15 prior to checking if it is
gt; below
gt;gt; gt; 75 and invoking the colour change if it is - leaving no change if it
gt;gt; gt; has
gt;gt; gt; no
gt;gt; gt; value or is 75 or above.
gt;gt; gt;
gt;gt; gt; I have tried using a COUNTA but cannot seem to get it to work.
gt;gt; gt;
gt;gt; gt; Can some kind soul help me out on this one (again) please?
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; Thanks amp; regards,
gt;gt; gt; -pp-
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;
Hi Biff,

No...no other conditions at all...

No formula in the cell either...wait a minute...would it matter if the
Format Cells/Number is set for a Percentage?
..
..
..
..
Yup...that's it...if I set it to a number it works as you guys thought it
would.

OK...how's about my setting it to a number instead of a percentage?

Or what should the formula be if I left it as a percentage?

lt;mind racing away heregt;

What would the Conditional Formatting be if I wanted H15 to be left
uncoloured if there is no value, red if the value is below 75 and green if
75 or above?

Sorry for all the questions...

Thanks amp; regards,
-=pp=-
quot;Biffquot; gt; wrote in message
...
gt; Hmmm.....
gt;
gt; Do you have any other conditions? Condition 2 and/or condition 3?
gt;
gt; If this is the ONLY condition it should work!
gt;
gt; Biff
gt;
gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt; ...
gt; gt; Thanks for the quick reply Biff.
gt; gt;
gt; gt; Did I miss something here or was my original post not as clear as it
gt; gt; should
gt; gt; have been...
gt; gt;
gt; gt; I tried your formula but even though at rest the cell is clear (good) if
I
gt; gt; enter 75 or above the Cell is still red (bad)?
gt; gt;
gt; gt; I only want it to change to Red if below 75 - if 75 or above I do not
want
gt; gt; to colour it - just leave it as a normal cell...
gt; gt;
gt; gt; Thanks for your patience!
gt; gt;
gt; gt; Regards,
gt; gt; -=pp=-
gt; gt;
gt; gt;
gt; gt; quot;Biffquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; Hi!
gt; gt;gt;
gt; gt;gt; Just a little tweak is all you need.
gt; gt;gt;
gt; gt;gt; Use the Formula Is option
gt; gt;gt; Formula is: =AND(ISNUMBER(H15),H15lt;75)
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; I'll never get the hang of this...:-(
gt; gt;gt; gt;
gt; gt;gt; gt; I had a similar problem recently that was solved in this ng (Thanks
gt; gt;gt; gt; Dave:-)
gt; gt;gt; gt; but have a related problem that I thought I could solve by applying
the
gt; gt;gt; gt; same
gt; gt;gt; gt; logic - alas it was not meant to be for me :-(
gt; gt;gt; gt;
gt; gt;gt; gt; I want to use Conditional Formatting to achieve the following - if
the
gt; gt;gt; gt; value
gt; gt;gt; gt; in Cell H15 is lower than 75 then colour it red.
gt; gt;gt; gt;
gt; gt;gt; gt; This I can achieve quite easily by using the following in Condition
1:
gt; gt;gt; gt;
gt; gt;gt; gt; If Cell Value is Less Than 75 then Format Pattern Red
gt; gt;gt; gt;
gt; gt;gt; gt; However I do not want the cell to be coloured Red if there is no
value
gt; gt; in
gt; gt;gt; gt; there at all - I only want to be able to turn the cell red after I
have
gt; gt;gt; gt; input the value and that value is less than 75
gt; gt;gt; gt;
gt; gt;gt; gt; Obviously I need to test for input in H15 prior to checking if it is
gt; gt; below
gt; gt;gt; gt; 75 and invoking the colour change if it is - leaving no change if it
gt; gt;gt; gt; has
gt; gt;gt; gt; no
gt; gt;gt; gt; value or is 75 or above.
gt; gt;gt; gt;
gt; gt;gt; gt; I have tried using a COUNTA but cannot seem to get it to work.
gt; gt;gt; gt;
gt; gt;gt; gt; Can some kind soul help me out on this one (again) please?
gt; gt;gt; gt;
gt; gt;gt; gt; --
gt; gt;gt; gt; Thanks amp; regards,
gt; gt;gt; gt; -pp-
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;
gt;would it matter if the Format Cells/Number is set for a Percentage?

Bingo!

So, change the formula to:

=AND(ISNUMBER(H15),H15lt;0.75)

Biff

quot;Pheasant Plucker®quot; gt; wrote in message
...
gt; Hi Biff,
gt;
gt; No...no other conditions at all...
gt;
gt; No formula in the cell either...wait a minute...would it matter if the
gt; Format Cells/Number is set for a Percentage?
gt; .
gt; .
gt; .
gt; .
gt; Yup...that's it...if I set it to a number it works as you guys thought it
gt; would.
gt;
gt; OK...how's about my setting it to a number instead of a percentage?
gt;
gt; Or what should the formula be if I left it as a percentage?
gt;
gt; lt;mind racing away heregt;
gt;
gt; What would the Conditional Formatting be if I wanted H15 to be left
gt; uncoloured if there is no value, red if the value is below 75 and green if
gt; 75 or above?
gt;
gt; Sorry for all the questions...
gt;
gt; Thanks amp; regards,
gt; -=pp=-
gt;
gt;
gt;
gt; quot;Biffquot; gt; wrote in message
gt; ...
gt;gt; Hmmm.....
gt;gt;
gt;gt; Do you have any other conditions? Condition 2 and/or condition 3?
gt;gt;
gt;gt; If this is the ONLY condition it should work!
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Thanks for the quick reply Biff.
gt;gt; gt;
gt;gt; gt; Did I miss something here or was my original post not as clear as it
gt;gt; gt; should
gt;gt; gt; have been...
gt;gt; gt;
gt;gt; gt; I tried your formula but even though at rest the cell is clear (good)
gt;gt; gt; if
gt; I
gt;gt; gt; enter 75 or above the Cell is still red (bad)?
gt;gt; gt;
gt;gt; gt; I only want it to change to Red if below 75 - if 75 or above I do not
gt; want
gt;gt; gt; to colour it - just leave it as a normal cell...
gt;gt; gt;
gt;gt; gt; Thanks for your patience!
gt;gt; gt;
gt;gt; gt; Regards,
gt;gt; gt; -=pp=-
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Biffquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt;gt; Hi!
gt;gt; gt;gt;
gt;gt; gt;gt; Just a little tweak is all you need.
gt;gt; gt;gt;
gt;gt; gt;gt; Use the Formula Is option
gt;gt; gt;gt; Formula is: =AND(ISNUMBER(H15),H15lt;75)
gt;gt; gt;gt;
gt;gt; gt;gt; Biff
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; I'll never get the hang of this...:-(
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I had a similar problem recently that was solved in this ng (Thanks
gt;gt; gt;gt; gt; Dave:-)
gt;gt; gt;gt; gt; but have a related problem that I thought I could solve by applying
gt; the
gt;gt; gt;gt; gt; same
gt;gt; gt;gt; gt; logic - alas it was not meant to be for me :-(
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I want to use Conditional Formatting to achieve the following - if
gt; the
gt;gt; gt;gt; gt; value
gt;gt; gt;gt; gt; in Cell H15 is lower than 75 then colour it red.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; This I can achieve quite easily by using the following in Condition
gt; 1:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; If Cell Value is Less Than 75 then Format Pattern Red
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; However I do not want the cell to be coloured Red if there is no
gt; value
gt;gt; gt; in
gt;gt; gt;gt; gt; there at all - I only want to be able to turn the cell red after I
gt; have
gt;gt; gt;gt; gt; input the value and that value is less than 75
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Obviously I need to test for input in H15 prior to checking if it is
gt;gt; gt; below
gt;gt; gt;gt; gt; 75 and invoking the colour change if it is - leaving no change if it
gt;gt; gt;gt; gt; has
gt;gt; gt;gt; gt; no
gt;gt; gt;gt; gt; value or is 75 or above.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I have tried using a COUNTA but cannot seem to get it to work.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Can some kind soul help me out on this one (again) please?
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; --
gt;gt; gt;gt; gt; Thanks amp; regards,
gt;gt; gt;gt; gt; -pp-
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;
Oops!

Missed this portion:

gt;What would the Conditional Formatting be if I wanted H15 to be left
gt;uncoloured if there is no value, red if the value is below 75 and green if
gt;75 or above?

Condition 1
Formula is: =AND(ISNUMBER(H15),H15lt;0.75)
Set color to RED

Condition 2
Formula is: =AND(ISNUMBER(H15),H15gt;=0.75)
Set color to GREEN

Biff

quot;Pheasant Plucker®quot; gt; wrote in message
...
gt; Hi Biff,
gt;
gt; No...no other conditions at all...
gt;
gt; No formula in the cell either...wait a minute...would it matter if the
gt; Format Cells/Number is set for a Percentage?
gt; .
gt; .
gt; .
gt; .
gt; Yup...that's it...if I set it to a number it works as you guys thought it
gt; would.
gt;
gt; OK...how's about my setting it to a number instead of a percentage?
gt;
gt; Or what should the formula be if I left it as a percentage?
gt;
gt; lt;mind racing away heregt;
gt;
gt; What would the Conditional Formatting be if I wanted H15 to be left
gt; uncoloured if there is no value, red if the value is below 75 and green if
gt; 75 or above?
gt;
gt; Sorry for all the questions...
gt;
gt; Thanks amp; regards,
gt; -=pp=-
gt;
gt;
gt;
gt; quot;Biffquot; gt; wrote in message
gt; ...
gt;gt; Hmmm.....
gt;gt;
gt;gt; Do you have any other conditions? Condition 2 and/or condition 3?
gt;gt;
gt;gt; If this is the ONLY condition it should work!
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Thanks for the quick reply Biff.
gt;gt; gt;
gt;gt; gt; Did I miss something here or was my original post not as clear as it
gt;gt; gt; should
gt;gt; gt; have been...
gt;gt; gt;
gt;gt; gt; I tried your formula but even though at rest the cell is clear (good)
gt;gt; gt; if
gt; I
gt;gt; gt; enter 75 or above the Cell is still red (bad)?
gt;gt; gt;
gt;gt; gt; I only want it to change to Red if below 75 - if 75 or above I do not
gt; want
gt;gt; gt; to colour it - just leave it as a normal cell...
gt;gt; gt;
gt;gt; gt; Thanks for your patience!
gt;gt; gt;
gt;gt; gt; Regards,
gt;gt; gt; -=pp=-
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Biffquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt;gt; Hi!
gt;gt; gt;gt;
gt;gt; gt;gt; Just a little tweak is all you need.
gt;gt; gt;gt;
gt;gt; gt;gt; Use the Formula Is option
gt;gt; gt;gt; Formula is: =AND(ISNUMBER(H15),H15lt;75)
gt;gt; gt;gt;
gt;gt; gt;gt; Biff
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; I'll never get the hang of this...:-(
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I had a similar problem recently that was solved in this ng (Thanks
gt;gt; gt;gt; gt; Dave:-)
gt;gt; gt;gt; gt; but have a related problem that I thought I could solve by applying
gt; the
gt;gt; gt;gt; gt; same
gt;gt; gt;gt; gt; logic - alas it was not meant to be for me :-(
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I want to use Conditional Formatting to achieve the following - if
gt; the
gt;gt; gt;gt; gt; value
gt;gt; gt;gt; gt; in Cell H15 is lower than 75 then colour it red.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; This I can achieve quite easily by using the following in Condition
gt; 1:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; If Cell Value is Less Than 75 then Format Pattern Red
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; However I do not want the cell to be coloured Red if there is no
gt; value
gt;gt; gt; in
gt;gt; gt;gt; gt; there at all - I only want to be able to turn the cell red after I
gt; have
gt;gt; gt;gt; gt; input the value and that value is less than 75
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Obviously I need to test for input in H15 prior to checking if it is
gt;gt; gt; below
gt;gt; gt;gt; gt; 75 and invoking the colour change if it is - leaving no change if it
gt;gt; gt;gt; gt; has
gt;gt; gt;gt; gt; no
gt;gt; gt;gt; gt; value or is 75 or above.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I have tried using a COUNTA but cannot seem to get it to work.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Can some kind soul help me out on this one (again) please?
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; --
gt;gt; gt;gt; gt; Thanks amp; regards,
gt;gt; gt;gt; gt; -pp-
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;
Thanks Biff,

I have moved away from the Percentage and formatted the cell as a number.

I see you use ISNUMBER in your formula

I currently have;

Condition 1
Formula Is =AND(H15gt;0,H15lt;75)
Pattern RED

Condition 2
Cell Value Is greater than or equal To 75
Pattern GREEN

Does that have any impact upon anything else or would the two ISNUMBER
formulae be the 'correct' way to go?

I only used AND as it was shorter, easier to type and reduced the chance of
me making a mistake!

One last question if I may...as I use H15 amp; H16 to input the scores of what
I call Pre and Post Test results is there a way to highlight H16 if it turns
out to be lower than the score in H15?

Theoretically the Post Test score would usually be higher but it would be
good to flag it if it turns out to be lower than the Pre Test score.

Would this be complicated to achieve?

Thanks amp; regards,
-=pp=-quot;Biffquot; gt; wrote in message
...
gt; Oops!
gt;
gt; Missed this portion:
gt;
gt; gt;What would the Conditional Formatting be if I wanted H15 to be left
gt; gt;uncoloured if there is no value, red if the value is below 75 and green
if
gt; gt;75 or above?
gt;
gt; Condition 1
gt; Formula is: =AND(ISNUMBER(H15),H15lt;0.75)
gt; Set color to RED
gt;
gt; Condition 2
gt; Formula is: =AND(ISNUMBER(H15),H15gt;=0.75)
gt; Set color to GREEN
gt;
gt; Biff
gt;
gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt; ...
gt; gt; Hi Biff,
gt; gt;
gt; gt; No...no other conditions at all...
gt; gt;
gt; gt; No formula in the cell either...wait a minute...would it matter if the
gt; gt; Format Cells/Number is set for a Percentage?
gt; gt; .
gt; gt; .
gt; gt; .
gt; gt; .
gt; gt; Yup...that's it...if I set it to a number it works as you guys thought
it
gt; gt; would.
gt; gt;
gt; gt; OK...how's about my setting it to a number instead of a percentage?
gt; gt;
gt; gt; Or what should the formula be if I left it as a percentage?
gt; gt;
gt; gt; lt;mind racing away heregt;
gt; gt;
gt; gt; What would the Conditional Formatting be if I wanted H15 to be left
gt; gt; uncoloured if there is no value, red if the value is below 75 and green
if
gt; gt; 75 or above?
gt; gt;
gt; gt; Sorry for all the questions...
gt; gt;
gt; gt; Thanks amp; regards,
gt; gt; -=pp=-
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Biffquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; Hmmm.....
gt; gt;gt;
gt; gt;gt; Do you have any other conditions? Condition 2 and/or condition 3?
gt; gt;gt;
gt; gt;gt; If this is the ONLY condition it should work!
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Thanks for the quick reply Biff.
gt; gt;gt; gt;
gt; gt;gt; gt; Did I miss something here or was my original post not as clear as it
gt; gt;gt; gt; should
gt; gt;gt; gt; have been...
gt; gt;gt; gt;
gt; gt;gt; gt; I tried your formula but even though at rest the cell is clear (good)
gt; gt;gt; gt; if
gt; gt; I
gt; gt;gt; gt; enter 75 or above the Cell is still red (bad)?
gt; gt;gt; gt;
gt; gt;gt; gt; I only want it to change to Red if below 75 - if 75 or above I do not
gt; gt; want
gt; gt;gt; gt; to colour it - just leave it as a normal cell...
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks for your patience!
gt; gt;gt; gt;
gt; gt;gt; gt; Regards,
gt; gt;gt; gt; -=pp=-
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Biffquot; gt; wrote in message
gt; gt;gt; gt; ...
gt; gt;gt; gt;gt; Hi!
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Just a little tweak is all you need.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Use the Formula Is option
gt; gt;gt; gt;gt; Formula is: =AND(ISNUMBER(H15),H15lt;75)
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Biff
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;Pheasant Plucker®quot; gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt; I'll never get the hang of this...:-(
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; I had a similar problem recently that was solved in this ng
(Thanks
gt; gt;gt; gt;gt; gt; Dave:-)
gt; gt;gt; gt;gt; gt; but have a related problem that I thought I could solve by
applying
gt; gt; the
gt; gt;gt; gt;gt; gt; same
gt; gt;gt; gt;gt; gt; logic - alas it was not meant to be for me :-(
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; I want to use Conditional Formatting to achieve the following - if
gt; gt; the
gt; gt;gt; gt;gt; gt; value
gt; gt;gt; gt;gt; gt; in Cell H15 is lower than 75 then colour it red.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; This I can achieve quite easily by using the following in
Condition
gt; gt; 1:
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; If Cell Value is Less Than 75 then Format Pattern Red
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; However I do not want the cell to be coloured Red if there is no
gt; gt; value
gt; gt;gt; gt; in
gt; gt;gt; gt;gt; gt; there at all - I only want to be able to turn the cell red after I
gt; gt; have
gt; gt;gt; gt;gt; gt; input the value and that value is less than 75
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Obviously I need to test for input in H15 prior to checking if it
is
gt; gt;gt; gt; below
gt; gt;gt; gt;gt; gt; 75 and invoking the colour change if it is - leaving no change if
it
gt; gt;gt; gt;gt; gt; has
gt; gt;gt; gt;gt; gt; no
gt; gt;gt; gt;gt; gt; value or is 75 or above.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; I have tried using a COUNTA but cannot seem to get it to work.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Can some kind soul help me out on this one (again) please?
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; --
gt; gt;gt; gt;gt; gt; Thanks amp; regards,
gt; gt;gt; gt;gt; gt; -pp-
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;