Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Changing cell colour depending on another cells value... | Excel Discussion (Misc queries) | |||
Fill colour a cell from the linked cell | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Function to return colour of formatted cell | Excel Worksheet Functions |