conditional formatting font color

[Joycelyn Anderson]

Can anyone walk me through conditional formatting cells so that

if the value is </= 24.00 the font is automatically green
if the value is > 24.00 the font is automatically red

Thank you!

 

[Chris Macro]

1. Highlights cells you want to apply the formatting to
2. Click Conditional formatting > New Rule
3. Select Format Only Cells That Contain
4. Enter in your first rule
5. Chose Format button and change font color to green
6. Click Ok
7. Repeat for your second rule

 

[Joycelyn Anderson]

Thank you so much!
And what is the proper format for the rules? Would they just look like this:

If </= 24.00
If > 24.00

 

[Chris Macro]

There are drop downs....so your first rule would look like this:

 

[Joycelyn Anderson]

Fantastic!

This is too much fun, thank you!

 

[Chris Macro]

No problem, glad I could help!