Conditional Formatting with Two Columns

**sombiatz** · 02-11-2014, 10:38 AM

Hi All,

I am trying to use conditional formatting in excel which I have never used before and I am having some trouble. I am trying to highlight a cell if that cell's value equals 0.00 and the cell before it equals "I". Here is a sample of my data:

A B

1 I 37.52
2 I 0.00
3 I 120.60
4 I 0.00
5 N 0.00
6 N 0.00

In this example I would be looking to highlight B2 and B4. Any help would be greatly appreciated. Thanks!

**Fotis1991** · 02-11-2014, 10:42 AM

In Conditional Formatting rules use this

Formula:

Please Login or Register  to view this content.

How can you use Conditional Formating.

--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.

**sombiatz** · 02-11-2014, 10:54 AM

Awesome Fotis!! Thanks for that! It worked just as I was hoping.

**Fotis1991** · 02-11-2014, 11:02 AM

You are welcome and thanks for the feedback.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.