Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding codes based on a font color
Hello. This is my first time posting. I am working with a rather large
excel file. It is color coded. Is there a formula that I can use that will take a color of the text - like "blue" and add a code into a given field for what that color means? thanks so much! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding codes based on a font color
No built in formula, but see
http://www.xldynamic.com/source/xld.ColourCounter.html -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ing" wrote in message ... Hello. This is my first time posting. I am working with a rather large excel file. It is color coded. Is there a formula that I can use that will take a color of the text - like "blue" and add a code into a given field for what that color means? thanks so much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
change font color based on a value | Excel Worksheet Functions | |||
How to sum data based on font or cell color? | Excel Worksheet Functions | |||
I can't figure out how to add values based on font color. | Excel Discussion (Misc queries) | |||
calculate numbers based on font color? | Excel Worksheet Functions |