Simple IF function require conditional addition

  Chillie 13:52 14 Jan 08
Locked

Hello my good people, hope you can help me.

The IF function works as follows:
Cell A1 shows Status either Active or Overdue
Cell A2 shows end date
Cell A3 shows current date
Formula is: "IF(A2>A3,"Active","Overdue")

lol, it works!!

How can I add to the formula this conditional format:

Make "Active" font colour Green
Make "Overdue" font colour Red

Any thoughts, suggestions would be much appreciated.

  VoG II 13:56 14 Jan 08

Use Formula Is and

A2>A3 to set green font

A2<=A3 to set red font.

  Chillie 18:39 14 Jan 08

Apologies for delay - decided to defrost the Freezer!!

Could not work out how to use "IS"; so created a conditional format dependent on value in A1 - Active or Overdue.

Can you show me how to include IS in my formula?

Once again, many thanks

Chillie

  VoG II 18:44 14 Jan 08

Sorry, I didn't explain very well.

When you bring up the Conditional Formatting dialog box by default it is set at Cell Value. If you click the arrow next to that you can change it to Formula Is. Then enter one of the formulas above, click format and set the colour. Then click the Add button to insert the other formula and formatting.

  Chillie 18:56 14 Jan 08

So simple when you know how!!

Again my thanks, will tick as resolved.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…