can excel change the color of a font based on criteria

[photoxprt1868]

Hello,

If I put a due date in a cell, can excel make it red automatically when it goes passed the due date?

Thank you in advance

 

[EBGreen]

Format > Conditional Formatting

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[Lilliabeth]

Yes!

Select the cell or range

Format > Conditional formatting

Cell Value is greater than =NOW()
Click Format button. On Font tab, choose red.

 

[VulcanJedi]

Not sure but you may want to verify the calculation tab in options to make sure that excel recalcultates cells, can't recall if conditional format is updated on the fly. F9 will recalc the entire sheet

Tranpkp

 

[xlbo]

conditional format is calculated along with workbook / worksheet calculation. If it is set to auto, all will work fine

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[photoxprt1868]

This works great.

Thank you very much. The only drawback is that it turns it red all the time. Would it be possible to turn it red if date is less than NOW() and if cell next to it has value = not completed?

Thank you very much

 

[tf1]

Of course. Check out the Format, Conditional Format dialog. You can use loads of arguments that include less than < and you can use multiple arguments including what the cell contains such as specific text. Play with the options and you can see how pwerful it can be.


Regards: tf1

 

[firefytr]

F9: Recalculate
Alt + F9: Calculate Range
Shift + F9: Recalculate Sheet(s)
Alt + Shift + F9: Fullcalculate Sheet(s)
Ctrl + Shift + F9: Recalculate including MixedModesheets
Ctrl + Alt + F9: Full calculate
Ctrl + Alt + shift + F9: Full calculate with dependency rebuild

To see more, check out

http://www.decisionmodels.com/FxlV2WhatsNew.htm

HTH

-----------
Regards,
Zack Barresse