Copy Cell Conditional Formatting to other cells

[Brandon Carraway]

I have a spreadsheet that tracks actual performance VS projected performance.

Work Area: C5:AG50

Actual Performance is filled in along ROW 5, and projected performance is filled along row 6; columns C-AG are for the days in the month (1-30).

If C5 is less than C6, then both cells need to turn red; I have started this, but by formatting each individual group (attached).
--How can I copy the formatting and paste the rules across numerous cells?

 

[NARAYANK991]

Hi ,

See if this is what you wanted.

Narayan

 

[Brandon Carraway]

Hi ,

See if this is what you wanted.

Narayan

Wholly Formula, Batman - This is exactly what I wanted. XD
I would have never guessed this.... This, my friend, is why you are an 'Excel Ninja'.