Get value of a highlighted cell

[29sandesh]

[TABLE="width: 2112"]
<tbody>[TR]
[TD]Right Image
[/TD]
[TD]Image 1
[/TD]
[TD]Image 2
[/TD]
[TD]Image 3
[/TD]
[/TR]
[TR]
[TD]=Formula Here
[/TD]
[TD]Image link 1 ( this cell is highlighted red by conditonal highlight rules)[/TD]
[TD]image link 2[/TD]
[TD]Image link 3[/TD]
[/TR]
</tbody>[/TABLE]

I have 3-15 Image columns as above and one of the cell is highlighted with RED color, i wish to have a formula wherein i can get the value of the highlighted cell. Example if above image 1 cell is RED color format, the value in Right Image Field should be Image 1 value. Can someone help. Will it require VBA or just IF function

 

[FormR]

Hi, what is your conditional formatting rule?

 

[29sandesh]

Hi, what is your conditional formatting rule?

Hi i am just using conditional format to highlight cell, "highlight cell, text that contains".

 

[FormR]

Hi i am just using conditional format to highlight cell, "highlight cell, text that contains".

Hi, specifically what is the rule - i.e. the "Format only cells with" detail? We can use the same logic to do your look up.