Hi, I'm new to VBA. I need a VBA macro which can change the colour of the cells based on rules applied. B1 B2 B3 B4 B5 0.00a 0.00a 0.00a 0.00a 0.00a 0.01a 0.02a 0.00a 0.00a 0.00a 0.03b 0.01ab 0.00a 0.00a 0.00a 0.06a 0.03a 0.07a 0.04a 0.06a 0.15a 0.18ab 0.27b 0.26b 0.22ab Rules are Any alphabet which is present in criteria column (B1) should not be highlighted in B2,B3 and B4 Any alphabet which is greater than the criteria (B1) should be highlighted in Green for B2,B3 and B4 . For eg : A is greater than B Any alphabet which is lesser than the criteria (B1) should be highlighted in Red for in B2,B3 and B4. For eg: A and B are lesser than C Thanks for your help !!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Changing the colour of the cells based on rules using VBA macros

Hi,

I'm new to VBA. I need a VBA macro which can change the colour of the cells based on rules applied.

Rules are

Any alphabet which is present in criteria column (B1) should not be highlighted in B2,B3 and B4
Any alphabet which is greater than the criteria (B1) should be highlighted in Green for B2,B3 and B4 . For eg : A is greater than B
Any alphabet which is lesser than the criteria (B1) should be highlighted in Red for in B2,B3 and B4. For eg: A and B are lesser than C

Thanks for your help !!