Compare Cell value and apply the cell color

Hi,

I would appreciate help on finding a way to compare two list (List 1 & List 1) and display "Yes" or "No" but also the should reflect the color of the cell in which that value is found

example

List 1 List 2 Status
1(Cell color Red) 5 Yes (This cell result should be "Yes"and should be green font color)
2 (Cell color Green) 9 no
3(Cell color Yellow) 0 no
4(Cell color Red) 1 Yes (This cell result should be "Yes"and should be red font color)
5(Cell color Green) 2
6(Cell color Green) 8

Hope that explains.

Appreciate any help

Cheers

@FDIBBINS - I managed to figure out the compare with VLOOKUP, but can't figure out Color ??

I guess background Color & Font color can be managed with "Conditional Formatting" in this case. Can you post a sample workbook here?

Attached a sample file

Originally Posted by Funtooskool

Attached a sample file

Hi,

I seem to have misunderstood the requirement here, Ford was correct, you would need a Macro for this.