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...