If-Then Shading

B

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.
 
N

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top