Hi
Just now when I tried to Format Cells - Fill colour & try to change
colour Nothing Happens!!
Anyone know why & how to fix please?
thank you
--
Martin
©¿©¬

Hi Martin,

Am Sat, 14 Apr 2012 14:30:54 +0100 schrieb Martin ©¿©¬:

> Just now when I tried to Format Cells - Fill colour & try to change
> colour Nothing Happens!!

is there a Conditional Format into these cells?


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

On Sat, 14 Apr 2012 15:36:20 +0200, Claus Busch
<(E-Mail Removed)> wrote:

>Hi Martin,
>
>Am Sat, 14 Apr 2012 14:30:54 +0100 schrieb Martin ©¿©¬:
>
>> Just now when I tried to Format Cells - Fill colour & try to change
>> colour Nothing Happens!!
>
>is there a Conditional Format into these cells?
>
>
>Regards

Hi Claus Busch
>is there a Conditional Format into these cells?
Not that I know off, I didn't create one

I am able to colour/un-coloured cells that have no colour, but unable
to colour or un-colour existing coloured cells.
This is my own spreadsheet & I coloured the cells last week?
--
Martin
©¿©¬

Hi Martin,

Am Sat, 14 Apr 2012 15:05:46 +0100 schrieb Martin ©¿©¬:

> I am able to colour/un-coloured cells that have no colour, but unable
> to colour or un-colour existing coloured cells.
> This is my own spreadsheet & I coloured the cells last week?

are you able to select these cells and choose "Format cells"?
If not, the sheet is protected.
Select the cells and choose CF to check if there is a CF working.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

F5>Special>Conditional Formats>OK

Any cells selected?


Gord

On Sat, 14 Apr 2012 15:05:46 +0100, Martin ©¿©¬
<(E-Mail Removed)> wrote:

>On Sat, 14 Apr 2012 15:36:20 +0200, Claus Busch
><(E-Mail Removed)> wrote:
>
>>Hi Martin,
>>
>>Am Sat, 14 Apr 2012 14:30:54 +0100 schrieb Martin ©¿©¬:
>>
>>> Just now when I tried to Format Cells - Fill colour & try to change
>>> colour Nothing Happens!!
>>
>>is there a Conditional Format into these cells?
>>
>>
>>Regards
>
>Hi Claus Busch
>>is there a Conditional Format into these cells?
>Not that I know off, I didn't create one
>
>I am able to colour/un-coloured cells that have no colour, but unable
>to colour or un-colour existing coloured cells.
>This is my own spreadsheet & I coloured the cells last week?

On Sat, 14 Apr 2012 15:36:20 +0200, Claus Busch
<(E-Mail Removed)> wrote:

>Hi Martin,
>
>Am Sat, 14 Apr 2012 14:30:54 +0100 schrieb Martin ©¿©¬:
>
>> Just now when I tried to Format Cells - Fill colour & try to change
>> colour Nothing Happens!!
>
>is there a Conditional Format into these cells?
>
>
>Regards
>Claus Busch

Hi Claus
Just realised that I did use a conditional format>formula is
=SUM($K4,$L4,$N4)<1
Silly me, HTHs
--
Martin
©¿©¬

On Sat, 14 Apr 2012 07:26:36 -0700, Gord Dibben <(E-Mail Removed)>
wrote:

>F5>Special>Conditional Formats>OK
>
>Any cells selected?
>
>
That doesn't work Gord
--
Martin
©¿©¬
>
>On Sat, 14 Apr 2012 15:05:46 +0100, Martin ©¿©¬
><(E-Mail Removed)> wrote:
>
>>On Sat, 14 Apr 2012 15:36:20 +0200, Claus Busch
>><(E-Mail Removed)> wrote:
>>
>>>Hi Martin,
>>>
>>>Am Sat, 14 Apr 2012 14:30:54 +0100 schrieb Martin ©¿©¬:
>>>
>>>> Just now when I tried to Format Cells - Fill colour & try to change
>>>> colour Nothing Happens!!
>>>
>>>is there a Conditional Format into these cells?
>>>
>>>
>>>Regards
>>
>>Hi Claus Busch
>>>is there a Conditional Format into these cells?
>>Not that I know off, I didn't create one
>>
>>I am able to colour/un-coloured cells that have no colour, but unable
>>to colour or un-colour existing coloured cells.
>>This is my own spreadsheet & I coloured the cells last week?

Works in 2003 and 2007 versions.

Which version are you running?


Gord

On Sat, 14 Apr 2012 16:05:23 +0100, Martin ©¿©¬
<(E-Mail Removed)> wrote:

>>F5>Special>Conditional Formats>OK
>>
>>Any cells selected?
>>
>>
>That doesn't work Gord

On Sat, 14 Apr 2012 16:17:21 +0200, Claus Busch
<(E-Mail Removed)> wrote:

>Hi Martin,
>
>Am Sat, 14 Apr 2012 15:05:46 +0100 schrieb Martin ©¿©¬:
>
>> I am able to colour/un-coloured cells that have no colour, but unable
>> to colour or un-colour existing coloured cells.
>> This is my own spreadsheet & I coloured the cells last week?
>
>are you able to select these cells and choose "Format cells"?
>If not, the sheet is protected.
>Select the cells and choose CF to check if there is a CF working.
>
>
>Regards

Hi Claus
I selected cells chose CF>clear rules>clear rules from selected cells
& it worked Hip-Hip
Now I can colour & re-colour to my heart's content
--
Regards
Martin
©¿©¬

BTW

What do you mean by "doesn't work"?

Error message? Nothing? No cells found?


Gord

On Sat, 14 Apr 2012 08:12:00 -0700, Gord Dibben <(E-Mail Removed)>
wrote:

>Works in 2003 and 2007 versions.
>
>Which version are you running?
>
>
>Gord
>
>On Sat, 14 Apr 2012 16:05:23 +0100, Martin ©¿©¬
><(E-Mail Removed)> wrote:
>
>>>F5>Special>Conditional Formats>OK
>>>
>>>Any cells selected?
>>>
>>>
>>That doesn't work Gord