Question on using formula's with cell formatting.
Say I have a list of companies and all those in red cells are considered 'tech' companies, whereas all those in blue are considered 'health-care' companies.
Can I create a formula in another tab that will give read 'tech' or 'health-care' in a cell based on the other tab's color?
Please see spreadsheet for more clarity.
Thanks!
not with regular formulas
heres UDF example
Function UDF(Target As Range) UDF = Replace(Target.Formula, "=", "") UDF = Range(UDF).Interior.ColorIndex End Function
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
dsciola 
Register To Reply
Bookmarks