Hi Experts --
I have a contiguous table of Sales Projections by Month which is 16 columns wide and about 600 rows deep. In each of the columns, except for the first one, I need a formula for conditional formatting that colors the cell if its value is greater than the value in the cell to its immediate left. Must repeat down all 600 rows.
I've spent some time searching for examples but so many are dependent on a fixed cell origin...
Is there a way to accomplish this with one rule?
Using Excel 2010.
Many Thanks!!!
Bookmarks