Format Cells - Fill colour Help
 

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
©¿©¬

Format Cells - Fill colour Help
 

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

Format Cells - Fill colour Help
 

On Sat, 14 Apr 2012 15:36:20 +0200, Claus Busch
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
©¿©¬

Format Cells - Fill colour Help
 

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

Format Cells - Fill colour Help
 

F5SpecialConditional FormatsOK

Any cells selected?


Gord

On Sat, 14 Apr 2012 15:05:46 +0100, Martin ©¿©¬
wrote:

On Sat, 14 Apr 2012 15:36:20 +0200, Claus Busch
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?

Format Cells - Fill colour Help
 

On Sat, 14 Apr 2012 15:36:20 +0200, Claus Busch
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 formatformula is
=SUM($K4,$L4,$N4)<1
Silly me, HTHs
--
Martin
©¿©¬

Format Cells - Fill colour Help
 

On Sat, 14 Apr 2012 07:26:36 -0700, Gord Dibben
wrote:

F5SpecialConditional FormatsOK

Any cells selected?


That doesn't work Gord
--
Martin
©¿©¬

On Sat, 14 Apr 2012 15:05:46 +0100, Martin ©¿©¬
wrote:

On Sat, 14 Apr 2012 15:36:20 +0200, Claus Busch
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?

Format Cells - Fill colour Help
 

Works in 2003 and 2007 versions.

Which version are you running?


Gord

On Sat, 14 Apr 2012 16:05:23 +0100, Martin ©¿©¬
wrote:

F5SpecialConditional FormatsOK

Any cells selected?


That doesn't work Gord

Format Cells - Fill colour Help
 

On Sat, 14 Apr 2012 16:17:21 +0200, Claus Busch
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 CFclear rulesclear rules from selected cells
& it worked Hip-Hip
Now I can colour & re-colour to my heart's content
--
Regards
Martin
©¿©¬

Format Cells - Fill colour Help
 

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
wrote:

Works in 2003 and 2007 versions.

Which version are you running?


Gord

On Sat, 14 Apr 2012 16:05:23 +0100, Martin ©¿©¬
wrote:

F5SpecialConditional FormatsOK

Any cells selected?


That doesn't work Gord

Format Cells - Fill colour Help
 

On Sat, 14 Apr 2012 08:12:00 -0700, Gord Dibben
wrote:

Works in 2003 and 2007 versions.

Which version are you running?

2010
I found Claus's suggestion to work perfectly
--
Martin
©¿©¬


Gord

On Sat, 14 Apr 2012 16:05:23 +0100, Martin ©¿©¬
wrote:

F5SpecialConditional FormatsOK

Any cells selected?


That doesn't work Gord

Format Cells - Fill colour Help
 

I see that, but I'm still curious about "doesn't work"


Gord

On Sat, 14 Apr 2012 16:15:39 +0100, Martin ©¿©¬
wrote:

On Sat, 14 Apr 2012 08:12:00 -0700, Gord Dibben
wrote:

Works in 2003 and 2007 versions.

Which version are you running?

2010
I found Claus's suggestion to work perfectly