| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ©¿©¬ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ©¿©¬ |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ©¿©¬ |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ©¿©¬ |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing fill colour of cells in a range | Excel Discussion (Misc queries) | |||
| Is there a way to add cells based on their shading / fill colour? | Excel Discussion (Misc queries) | |||
| Sum cells by fill colour | Excel Discussion (Misc queries) | |||
| fill cells with colour if content of another cell has CR | Excel Programming | |||
| Sum cells according to colour fill | Excel Discussion (Misc queries) | |||
![Martin ©¿©¬[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
