....and what is(are) the condition(s) you want to highlight?

"MDewitz" wrote:

In can't figure out how to put conditinal formating on multiple cells at one
time with each cell requiring a different value. Since the conditional
formatting is based on different values for each section and each month, I
find myself having to put a conditional formatting on every cell. For
example if I copy the formatting for Sec 1-4 for Jul into Aug, the
conditional formatting is then based on the projected data for Jul Sec 1-4 vs
Aug.

Actual data Projected data
JUL AUG JUL AUG
Sec 1 5,129 5,397 4,859 5,340
Sec 2 823 1,032 771 886
Sec 3 1,293 1,196 945 1,047
Sec 4 113 136 135 142

Can you help? Thanks.