Color Code Formula Required

[rush2rajen]

Hi Excel Gurus,

I got stuck on the excel sheet. Is it possible that on Colour Code we can write down if formula or any other to come to a conclusion.

File attached.
Please help.

Thanks
Raj

 

[Somendra Misra]

Hi Raj,

What should be the output of formula that you required?

Regards,

 

[rush2rajen]

Hi Misraji,

If the cell is yellow in colour then in REMARKs column it should be named as Negative and if there is no colour then as Positive.

Thanks
Raj

 

[Somendra Misra]

@rush2rajen

Go through below link which has code for a UDF to return cell color value. Once you get the cell value, you can use it with an IF function to get your desired result.

http://www.excelfox.com/forum/f22/g...ether-from-conditional-formatting-or-not-338/

Regards,

 

[rush2rajen]

Thanks Misraji.