Hello ,

I have an excel sheet with Two Columns, - Column A and B.

Each Column has more than 200 rows, What I want to do is to compare data of both columns and then Color the Specific Cells using Conditional Formatting.

For Eg:- If A5 < B5 then A5 should Go Red. and same with all other cells of Column A , Please tell me how can i do this , As I can't do it manually for more than 200 rows.

Best Regards

Gagan