Thread: Converting color coded cells into numbers (Excel 2007, Windows Vista)
View Single Post
 
Old 02-10-2021, 06:24 AM
Purfleet Purfleet is offline Windows 10 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