If-Then Shading

Brian · Apr 7, 2004

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 · Apr 7, 2004

Format|Conditional Formatting might do it for you.

Norman Harker · Apr 7, 2004

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 · Apr 7, 2004

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

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

--

Dave Peterson
(e-mail address removed)
.