canischintsomani
New member
- Joined
- Jun 5, 2014
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hello
I need VB code for conditional formatting for following criteria
if the cell value in column b is grater than cell value in column a, cell in column should b should turn in to green, if it is lesser than it should turn in to red, and if its equal no change.
i know this can be resolved with conditional formatting option in excel, but in that case i have to apply on each cell one by one.
my data base is too big, so i want solution with VB codes.
Thanks a ton
I need VB code for conditional formatting for following criteria
if the cell value in column b is grater than cell value in column a, cell in column should b should turn in to green, if it is lesser than it should turn in to red, and if its equal no change.
i know this can be resolved with conditional formatting option in excel, but in that case i have to apply on each cell one by one.
my data base is too big, so i want solution with VB codes.
Thanks a ton