Best approach for conditional formatting?
 

I would like to make numbers within certain ranges show up in different
colors. I'm very new to Excel, but have programmed scripts in Access and
know what an Access macro is - as well as the Access "conditional
formatting" feature. What is the best approach to take in Excel? And could
you give me some pointers as to the first steps to take to get into the
recommended environment?

Best approach for conditional formatting?
 

You'll need to describe what kind of data will be in the cells
and which formats would be associated with which data values.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Laurel" wrote in message
...
I would like to make numbers within certain ranges show up in different
colors. I'm very new to Excel, but have programmed scripts in Access and
know what an Access macro is - as well as the Access "conditional
formatting" feature. What is the best approach to take in Excel? And
could you give me some pointers as to the first steps to take to get into
the recommended environment?

Best approach for conditional formatting?
 

Numeric data <80 would remain black - no extra steps.
8190 - blue
91-100 - red
above 100- fuschia

"Ron Coderre" wrote in message
...
You'll need to describe what kind of data will be in the cells
and which formats would be associated with which data values.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Laurel" wrote in message
...
I would like to make numbers within certain ranges show up in different
colors. I'm very new to Excel, but have programmed scripts in Access and
know what an Access macro is - as well as the Access "conditional
formatting" feature. What is the best approach to take in Excel? And
could you give me some pointers as to the first steps to take to get into
the recommended environment?

Best approach for conditional formatting?
 

Click on FORMAT Conditional Formatting

Condition 1: Cell Value Is Between 81 90 (Set Format)
Condition 2: Cell Value Is Between 91 100 (Set Format)
Condition 3: Cell Value Is Greater Than 100 (Set Format)

Good Luck,
Les


"Laurel" wrote:

Numeric data <80 would remain black - no extra steps.
8190 - blue
91-100 - red
above 100- fuschia

"Ron Coderre" wrote in message
...
You'll need to describe what kind of data will be in the cells
and which formats would be associated with which data values.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Laurel" wrote in message
...
I would like to make numbers within certain ranges show up in different
colors. I'm very new to Excel, but have programmed scripts in Access and
know what an Access macro is - as well as the Access "conditional
formatting" feature. What is the best approach to take in Excel? And
could you give me some pointers as to the first steps to take to get into
the recommended environment?

Best approach for conditional formatting?
 

Perfect!!! Thanks so much!
I can't believe I couldn't find that "conditional formatting" menu item.
It's in just the obvious place. (Maybe that's the problem .... Who would
look in the obvious place???? :-) )
"WLMPilot" wrote in message
...
Click on FORMAT Conditional Formatting

Condition 1: Cell Value Is Between 81 90 (Set Format)
Condition 2: Cell Value Is Between 91 100 (Set Format)
Condition 3: Cell Value Is Greater Than 100 (Set Format)

Good Luck,
Les


"Laurel" wrote:

Numeric data <80 would remain black - no extra steps.
8190 - blue
91-100 - red
above 100- fuschia

"Ron Coderre" wrote in message
...
You'll need to describe what kind of data will be in the cells
and which formats would be associated with which data values.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Laurel" wrote in message
...
I would like to make numbers within certain ranges show up in different
colors. I'm very new to Excel, but have programmed scripts in Access
and
know what an Access macro is - as well as the Access "conditional
formatting" feature. What is the best approach to take in Excel? And
could you give me some pointers as to the first steps to take to get
into
the recommended environment?