Formula Help

  • Thread starter Thread starter jakecarey
  • Start date Start date
J

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
 
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
 
Back
Top