Hey everyone,

I'm working on conditionally formatting 200+ cells to show up as either red or green based on if the numbers in them are greater or less than they were in the previous report. Its very tedious to have to create two separate rules to do this. Can anyone think of a way to do a macro or something to automate it?

The two charts are exactly the same size so the two cells that are being compared are always the same distance from each other if that helps. Looks like this basically:

If $K$1>$A$1 then color green
If $K$1<$A$1 then color red

next

If $K$2>$A$2 then color green
If $K$2<$A$2 then color red

Their are like 10 tables that are in 5x5 matrices

thanks in advance!