Simple IF function require conditional addition

  Chillie 13:52 14 Jan 2008

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 2008

Use Formula Is and

A2>A3 to set green font

A2<=A3 to set red font.

  Chillie 18:39 14 Jan 2008

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


  VoG II 18:44 14 Jan 2008

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 2008

So simple when you know how!!

Again my thanks, will tick as resolved.

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

Elsewhere on IDG sites

WPA2 Hack Latest News: How Secure is your Wi-Fi?

Photoshop CC 2018 released with new Curvature Pen and better brush tools

Best kids apps for iPhone & iPad

Comment utiliser Twitter ?