Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2021, 06:17 PM
angExcelentflea angExcelentflea is offline Converting color coded cells into numbers (Excel 2007, Windows Vista) Windows XP Converting color coded cells into numbers (Excel 2007, Windows Vista) Office 2007
Novice
Converting color coded cells into numbers (Excel 2007, Windows Vista)
 
Join Date: Aug 2019
Posts: 3
angExcelentflea is on a distinguished road
Default Converting color coded cells into numbers (Excel 2007, Windows Vista)

Greetings-



I am a Windows Vista user using Excel 2007. I have recently received a large Excel dataset containing colors that need to be converted to numbers, e.g. red cells should be 1, blue cells should be 2, etc. I am seeking a way to "find and replace" the color data with numbers efficiently.

Thank you in advance, all suggestions are greatly appreciated. If my post is in the wrong section, kindly tell me where to post this concern of mine...
Reply With Quote
  #2  
Old 02-10-2021, 06:24 AM
Purfleet Purfleet is offline Converting color coded cells into numbers (Excel 2007, Windows Vista) Windows 10 Converting color coded cells into numbers (Excel 2007, Windows Vista) Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

I think the only way would be via VBA, do you have an example worksheet and a key for the colour vs numbers?
Reply With Quote
Reply

Tags
excel 2007

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting color coded cells into numbers (Excel 2007, Windows Vista) Converting table to text (and back) with carriage returns in cells, split and merged cells ndajko Word 5 11-04-2019 07:53 AM
Converting color coded cells into numbers (Excel 2007, Windows Vista) License Question - Can I Move Office 2010 From Vista to Windows 7, Same Computer? Tumbleweed Office 1 01-28-2013 06:37 AM
How can I fix a print view problem that causes it to stop working.. Excel 2007, Vista birdie123 Excel 0 08-18-2012 12:02 PM
Converting color coded cells into numbers (Excel 2007, Windows Vista) After upgrading to windows 7 word 2007 page numbers submenus grayed out JackMUr Word 3 05-21-2011 05:16 AM
Moving from Vista to Windows 7 zyzzyva57 Office 0 12-18-2009 04:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft