Help with conditional formatting syntax

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Hyett - 11 Oct 2007 10:21 GMT

I wonder if someone here could help?

I have a spreadsheet where I want to change the font colour of a cell
depending on the content to the cell to its immediate left - but only if
the cell to the left isn't blank.

To illustrate :

A B
1 12 16

If B1>A1 the font colour s/b one thing, if B1<A1, another colour, and if
A1 is empty (or if A1=B1), leave the cell unchanged.

It is the syntax for detecting whether A1 is empty that foxes me.

TIA.

Signature

Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

Reply to this Message

papou - 11 Oct 2007 10:42 GMT

Hello Paul
Use either
=ISBLANK(A1)
Or
=A1=""

Thus with your specs:
First condition, formula
=AND(NOT(ISBLANK(A1)),B1>A1)
Second condition formula:
=AND(NOT(ISBLANK(A1)),B1<A1)

HTH
Cordially
Pascal

>I wonder if someone here could help?
>
[quoted text clipped - 13 lines]
>
> TIA.

Reply to this Message

Paul Hyett - 11 Oct 2007 18:38 GMT

In microsoft.public.excel on Thu, 11 Oct 2007, papou
<cpapoupasbon@?.net.invalid> wrote :

>Hello Paul
>Use either
[quoted text clipped - 7 lines]
>Second condition formula:
>=AND(NOT(ISBLANK(A1)),B1<A1)

Thank you - much appreciated. It worked after a little tweaking.

Also to anyone else who replies.

Signature

Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

Reply to this Message

Stan Brown - 11 Oct 2007 11:20 GMT

Thu, 11 Oct 2007 09:21:56 GMT from Paul Hyett
<vidcapper@invalid83261.co.uk>:

> It is the syntax for detecting whether A1 is empty that foxes me.

=isblank(A1)

Signature

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

Reply to this Message