Skip to Content
0
Former Member
Sep 16, 2014 at 11:04 AM

How to do conditional formatting between two columns in excel

653 Views

Hi Experts,

I want to do conditional formatting between actual cost and plan cost column of excel, you can see screen shot of query data in excel.

Here I want to conditional formatting like, if actual cost is less than with plan cost then I want to show actual cost in red color.

Please help me to solve this issue.

Best Regards

Nilesh P

Attachments

conditional.JPG (76.4 kB)