Either select all the cells first then go to FormatCF and enter the rules.

Watch out for Excel making Absolute addresses like $I$1

OR use the Format Paintbrush to copy the fomatting.


Gord Dibben MS Excel MVP


On Wed, 18 Jul 2007 14:06:01 -0700, Kyle wrote:

Im creating a rate tracking sheet for a mortgage company. the rates are in
one column and will set off a color of red if they are .5% under the target
rate or blue if if the rate is .25%-.5%. Both of these columns are right next
to eachother. (Columns H and I) I need to make about 1500 rows and so far ive
done about 50 manually without copy and pasting. its very tedious if anybody
has any formulas that would be very helpful.

Cheers...