"David McRitchie" wrote:
I see the first two in the thread as replies by Pete, wonder if it is
an old thread and even more than two months old so we don't even
see it in a newsgroup. Don't know if that is the problem, but Google
doesn't even warn someone if the thread is old. With such a common
subject -- chances are Google has overlapped many threads and you
won't really be able to tell mcuh.

Thanks, David. With your hint, I found the "complete" thread in Google,
and it's with the OP intact (it's a new thread <g) ..

---- OP's query --------
From:
Newsgroups: microsoft.public.excel.newusers
Subject: Conditional formatting
Date: 31 May 2006 05:05:26 -0700

I am trying to create a holiday planner for the GP practice where I
work, and have have inserted a number for available appointments a GP
has in cell B1, but when they go on holiday I insert a H in cell A1 and

it turns yellow, and in cell B1 I want it to change to overide the
number of appointments by placing a 0 and also turning it yellow, I can

get the colour to change but not the number, I have used formula is:
=IF(A1="H",0) but it is not working, it works as a basic if function
but not in conditional formatting, please help.
---------------
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---