Thanks Ken.

This would be typical:
Range: D2:P500
Criteria: <1 cell turns yellow, 1 cell turns red
Limits: values will range from 0 - 2, disallow "---"

I'll generate these spreadsheets daily, format remains
consistent, but the data content and filename will
change. I was thinking that wrapping vb code in a macro
would work best in Excel. Is there a better way?

T-I-A,
Randy

-----Original Message-----
When you say you will use it frequently, why does that
drive a macro solution?
Conditional formatting is dynamic, and wuill change
automatically as your data changes,
without any intervention needed on your part. If you
give us the ranges and the limits
and criteria, we should be able to help you.

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------
------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------
------------------



wrote in message
...
Need to apply conditional formatting to cells within
subtotalled rows in lengthy spreadsheets, and would
prefer
to do so in a macro, as I will use this solution
frequently. Conditional formatting would turn cells red
for greaterthan values, yellow for lessthan values.
Subtotalling occurs after varying number of rows of data
(~6 - 20), and subtotalled cells occur in columns d-p.

Thanks!


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date:
16/10/2003


.