VBA code for Conditional formating for more rows and columns and criteria

Hi friends, kindly help us with a VBA code for conditional formatting as mentioned in the title, attached the sample sheet for the reference, where we need to pull the colors is mentioned.

The coding should apply in G and H column in the background.

I need a VBA code and I use excel 2010

FWIW:

Please Login or Register  to view this content.

HI All,

Thanks for the response, but I need the formatting done behind ma results. Check the below explanation

VBA codes for conditional formatting which has multiple criteria. Example Column A1:A10 has names, each names has three criteria from B1:D10 and Column E has achieved result for each names... results Should fetch in Column E. So the Macro or VBA codes should check each criteria and highlight Column in different colors with the results in the front.

Example: A1: Ramesh has achieved 98, B1:D1 = (B1=99,C1=95,D1=90), Result is 98 with Yellow background
Formulas for example =if(E1>=B1,"Green",if(and(E1>=C1,E1<B1),"Yelow",if(and(E1>=D1,E1<C1),"Orange","Red")))
Note :Im Using Microsoft Excel 2010.

Please reply ASAP very Urgent.

Hope u got it. u can also mail me at [email protected] or let me know I can call u to fix this thanks.....

Conditional formatting.jpg Attached an image for your reference