Use Cell Color as reference point in Vlookup

jaguinaga

New Member
Joined
Aug 10, 2021
Messages
16
Office Version
  1. 365
Platform
  1. Windows
Hi, I am trying to use a vlookup to grab a value based upon the color green. Is there a way to reference a cell's value based upon what color it is conditionally formatted as?

Ex:

input: vlookup(for green, range a1:r10, column 5)

output: number value within the green cell
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,855
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
Platform
  1. Windows
If it is conditionally formatted then there is a condition behind the format. Look for the condition. But depending on your case vlookup may not be the way to do it
 

jaguinaga

New Member
Joined
Aug 10, 2021
Messages
16
Office Version
  1. 365
Platform
  1. Windows
If it is conditionally formatted then there is a condition behind the format. Look for the condition. But depending on your case vlookup may not be the way to do it
Can you provide more details please?
 

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,855
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
Platform
  1. Windows
Can you provide more details please?
You first. ;) This is actually a line that should come from me. Please provide more details about your data and conditions.
If you're asking a general question, the short answer is: No, you cannot lookup the cell color.
 

jaguinaga

New Member
Joined
Aug 10, 2021
Messages
16
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

You first. ;) This is actually a line that should come from me. Please provide more details about your data and conditions.
If you're asking a general question, the short answer is: No, you cannot lookup the cell color.
The condition looks at the highest number in each column and highlights that number's cell green. I need to be able to grab the highest number per column based on the conditional format of green.
 

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,855
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
Platform
  1. Windows
You can't lookup the green color, but you can lookup the highest number.
Do you only need the number, or the cell that contains it?
 

jaguinaga

New Member
Joined
Aug 10, 2021
Messages
16
Office Version
  1. 365
Platform
  1. Windows
You can't lookup the green color, but you can lookup the highest number.
Do you only need the number, or the cell that contains it?
I need the value that is associated with the color because the formula has to apply to a range of columns where each column has a different set of numbers
 

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,855
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
Platform
  1. Windows
Can you post some extract of your data and post it here. And try to explain in details what exactly are you trying to accomplish.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,972
Messages
5,767,394
Members
425,410
Latest member
SmittyT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top