Formula Help

[jakecarey]

I am working with this formula

=IF(E25=0,"Even",IF(E25<0,"Short","Over"))

I need the "Short" to apear red and the "Over" to apear blue.

Can someone edit my formula to make that happen?

Thank you.

Jake Care

 

[nh786]

Use Conditional formatting under Format--> conditional formatting..

 

[jakecarey]

Im sorry, im not that smart. Once I do that what do I do?

Jak

 

[nh786]

Select the range first where you want this conditions applied

Then go to Format --> Conditional formatting

Choose "cell value is"
Choose " Equal to "
Type "Short"

Click on Format Button
Select the desired format

Then

Click on Add>> button
and repeat the steps above

You can have upto 3 conditions adde

 

[jakecarey]

Worked, thank yo