Conditional format based on multiple criteria macro

Hi all,

First post so forgive me if I am leaving out any critical information.

I have a data set with four years of data for many different locations. I am trying to light up rows where there is a particular column that has been 0 for the most recent two years at any given location. We can call these columns FY, Location, Cost for demonstration purposes.

I am trying to make a macro out of this because I have hundreds of spreadsheets for different data at each location that I need to apply this formatting to. Unfortunately I have had little in the way of success and would love some tips.

Thank you,

Scott

Yes that is correct. So for my example I need When Cost = 0 in both FY 2012 and 2013 to highlight all rows for that Location.

Thank you for your replies!

This does not seem to be accomplishing what I am trying to do. Let me give a little more information (The data is sensitive otherwise I would provide a sample).

Column A is FY, The only possible values are 2010,2011,2012,2013.

Column F is location. There are hundreds of different locations. Each has a text string as a name. Each has data for all 4 years.

Column T is cost.

So for example, if location jacksonville had 0 cost for years 2012 and 2013 I would want all rows where the location = jacksonville to be highlighted.

I hope this paints a more clear picture of my task and again, thank you for your help!

The code above is only highlighting those rows where cost = 0

I am trying to get it to highlight all rows for one location if the most recent two years have a cost of 0.

In the attached spreadsheet I have created a sample that shows what it would look like if done as intended.

Highlighting rows corresponding to a location that has 0 cost the most recent two years.

It appears that code is just highlighting the whole sheet. Any other ideas? I appreciate all of the help.

There is no macro in that workbook you sent me..

It seems to work in the file you sent me, but when I apply it to my data it highlights the entire sheet. I cannot figure out why.

I cannot send the file. Even after deleting everything but those rows, it still highlights the whole sheet

Columns I mean, not rows