% attendance in red if below 50%

[Ellen]

Hello,
I've made a sheet to track attendance with the following
formula: =SUM(B8:F8)/COUNTA(B8:F8), which works quite
well. I'd like the color of the percentage to change from
black to red when the percentage is below 50%. How would
that be done?

Thank you so much in advance.
Happy New Year!

Ellen

 

[Norman Harker]

Hi Ellen!

Use conditional formatting

Select the cell or range of cells that this is applied to.

Format > Conditional Format
Leave Cell Value Is
Select "Less than" from middle drop down
Type 50% in right drop down
Press Format button
Select your format
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.

 

[Martin]

Conditional formatting

 

[Guest]

Thank you, Norman! It works like a champ!

It looks like you're from "Down Under", but hey, we love
you Aussies.

Ellen