Conditional Formatting Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Code Numpty - 31 Mar 2008 11:24 GMT

I am trying to apply a conditional format to a range of cells containing a
version of this formula.
=IF(H16=0,"N/A",(H16-J16)*100/J16)

If the cell value is greater than 2, I need the format to change. However,
if the cell value is "N/A" the conditional formatting as still applied.

I have tried Formula Is =AND(O16>2,O16<>"")

Reply to this Message

Pete_UK - 31 Mar 2008 11:38 GMT

Try this change to your CF formula:

=AND(O16>2,O16<>"N/A")

Hope this helps.

Pete

On Mar 31, 11:24 am, Code Numpty
<CodeNum...@discussions.microsoft.com> wrote:

> I am trying to apply a conditional format to a range of cells containing a
> version of this formula.
[quoted text clipped - 4 lines]
>
> I have tried Formula Is =AND(O16>2,O16<>"")

Reply to this Message

Code Numpty - 31 Mar 2008 11:50 GMT

Spot on Pete, thanks!

Reply to this Message

Pete_UK - 31 Mar 2008 11:57 GMT

You're welcome.

Pete

On Mar 31, 11:50 am, Code Numpty
<CodeNum...@discussions.microsoft.com> wrote:

> Spot on Pete, thanks!

Reply to this Message