Format Cells - Fill colour Help

  • Thread starter Thread starter Martin ©¿©¬
  • Start date Start date
M

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
 
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!!
Click to expand...

is there a Conditional Format into these cells?


Regards
Claus Busch
 
Hi Martin,

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


is there a Conditional Format into these cells?


Regards
Click to expand...

Hi Claus Busch
is there a Conditional Format into these cells?
Click to expand...
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?
 
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?
Click to expand...

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
 
Hi Martin,

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


is there a Conditional Format into these cells?


Regards
Claus Busch
Click to expand...

Hi Claus
Just realised that I did use a conditional format>formula is
=SUM($K4,$L4,$N4)<1
Silly me, HTHs
 
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
Click to expand...

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
 
Back
Top