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
Ex:
input: vlookup(for green, range a1:r10, column 5)
output: number value within the green cell