If-Then Shading

[Brian]

What I'd like to be able to do is have Excel shade a cell
if a student scored less than an 80. I have yet to find
anything that will do this.

 

[Dave Peterson]

Format|Conditional Formatting might do it for you.

 

[Norman Harker]

Hi Brian!

Use:
Format > Conditional Formatting
First drop down: Cell value is:
Second drop down: less than
Type in 80 in third box
Format button
Patterns tab
Select colour
OK
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Brian]

Wow...talk about a stupid fix...thanks alot!

-----Original Message-----
Format|Conditional Formatting might do it for you.


--

Dave Peterson
(e-mail address removed)
.