Format Cells - Fill colour Help

[Martin ©¿©¬]

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

 

[Claus Busch]

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

 

[Martin ©¿©¬]

Hi Martin,

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


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?

 

[Claus Busch]

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

 

[Gord Dibben]

F5>Special>Conditional Formats>OK

Any cells selected?


Gord

 

[Martin ©¿©¬]

Hi Martin,

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


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

F5>Special>Conditional Formats>OK

Any cells selected?

That doesn't work Gord

 

[Gord Dibben]

Works in 2003 and 2007 versions.

Which version are you running?


Gord

 

[Martin ©¿©¬]

Hi Martin,

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


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

 

[Gord Dibben]

BTW

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

Error message? Nothing? No cells found?


Gord

 

[Martin ©¿©¬]

Works in 2003 and 2007 versions.

Which version are you running?

2010
I found Claus's suggestion to work perfectly

 

[Gord Dibben]

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


Gord