Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S S
 
Posts: n/a
Default Help with cell colour

From a spreadsheet I was using a while back and now updating, I had some
cells which had a pattern and a `fill` colour in them, I am sure I did this
from Format cells /Pattern /Colour.
It was a light browny beige colour but there does not appear to be a match
for it on the drop down color menu so when I take the nearest colour to it I
have two different shades. I cant fathom this out, have I maybe accessed a
tranclucent colour from somewhere that would make the older ones appear
lighter. I could change them all to the new slightly darker shade (but
prefer the lighter) but would still like to know what I have done.

Any ideas, I hope I have explained ok.


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Help with cell colour

Sounds like a custom colour. If you go to ToolsOptionsColor, you should
see some extra colours in the dialog, maybe it is there. If so, you could
select it, and clickModifyCustom and get its RGB value. You could then
select a standard colour and set that to the RGB value, thus creating an
easily accessed colour.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"S S" wrote in message
.uk...
From a spreadsheet I was using a while back and now updating, I had some
cells which had a pattern and a `fill` colour in them, I am sure I did

this
from Format cells /Pattern /Colour.
It was a light browny beige colour but there does not appear to be a match
for it on the drop down color menu so when I take the nearest colour to it

I
have two different shades. I cant fathom this out, have I maybe accessed a
tranclucent colour from somewhere that would make the older ones appear
lighter. I could change them all to the new slightly darker shade (but
prefer the lighter) but would still like to know what I have done.

Any ideas, I hope I have explained ok.




  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S S
 
Posts: n/a
Default Help with cell colour

Thanks Bob thats it sorted.


"Bob Phillips" wrote in message
...
Sounds like a custom colour. If you go to ToolsOptionsColor, you should
see some extra colours in the dialog, maybe it is there. If so, you could
select it, and clickModifyCustom and get its RGB value. You could then
select a standard colour and set that to the RGB value, thus creating an
easily accessed colour.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"S S" wrote in message
.uk...
From a spreadsheet I was using a while back and now updating, I had some
cells which had a pattern and a `fill` colour in them, I am sure I did

this
from Format cells /Pattern /Colour.
It was a light browny beige colour but there does not appear to be a
match
for it on the drop down color menu so when I take the nearest colour to
it

I
have two different shades. I cant fathom this out, have I maybe accessed
a
tranclucent colour from somewhere that would make the older ones appear
lighter. I could change them all to the new slightly darker shade (but
prefer the lighter) but would still like to know what I have done.

Any ideas, I hope I have explained ok.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
Changing cell colour depending on another cells value... Web master Excel Discussion (Misc queries) 3 January 10th 06 12:30 PM
Fill colour a cell from the linked cell Stephen C Excel Discussion (Misc queries) 1 September 28th 05 03:56 PM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Function to return colour of formatted cell ExcelMonkey Excel Worksheet Functions 3 November 1st 04 05:54 PM


All times are GMT +1. The time now is 02:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"