I have a spreadsheet that we use to track budget numbers. I need a
macro that will change the text color to red for any cell that is less
than the specified budget number. EX: Cell C5 is 180.00. I want any
cells that I specify, (say C6-C12), to be red if the value is less
than C5. It sounds simple, but I just cannot seem to get it. HELP!!!

Use conditional formatting.

Select the cells, go to FormatConditional Formatting, change condition 1 to
Formula Is, and ad a formula =$C5C6, click font, select a colour from the
patterns tab, and exit

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Chuck Scott" wrote in message
m...
I have a spreadsheet that we use to track budget numbers. I need a
macro that will change the text color to red for any cell that is less
than the specified budget number. EX: Cell C5 is 180.00. I want any
cells that I specify, (say C6-C12), to be red if the value is less
than C5. It sounds simple, but I just cannot seem to get it. HELP!!!

This is the ideal place to use conditional formating.
Just go to Format|Conditional formating and set it up as
you want.

-----Original Message-----
I have a spreadsheet that we use to track budget
numbers. I need a
macro that will change the text color to red for any cell
that is less
than the specified budget number. EX: Cell C5 is
180.00. I want any
cells that I specify, (say C6-C12), to be red if the
value is less
than C5. It sounds simple, but I just cannot seem to get
it. HELP!!!
.

Use conditional formatting... no VBA required


"Chuck Scott" wrote in message
m...
I have a spreadsheet that we use to track budget numbers. I need a
macro that will change the text color to red for any cell that is less
than the specified budget number. EX: Cell C5 is 180.00. I want any
cells that I specify, (say C6-C12), to be red if the value is less
than C5. It sounds simple, but I just cannot seem to get it. HELP!!!