Ask Your Question

how can i make all later date red ?

asked 2017-04-30 13:18:10 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

how can i make all later date red ?

edit retag flag offensive close merge delete


What application - Calc, Writer, something else?

Later than what - greater than the current date, or something else?

Do you want red the text, background, border or something else?

robleyd gravatar imagerobleyd ( 2017-04-30 13:25:32 +0200 )edit

on calc , later then today's date and should update daily . text should get red ?

zuren gravatar imagezuren ( 2017-04-30 13:29:59 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-04-30 14:42:46 +0200

librebel gravatar image

You can use the TODAY() function, like this:

1) Select the cell for which to apply Conditional Formatting,
2) Click on the menu "Format:Conditional Formatting:Condition..."
3) in the first listbox, select the item "Cell value is"
3) in the second listbox, select the item "greater than"
4) in the text box type: "TODAY()"
5) Apply Style in red,
6) click the OK button.
edit flag offensive delete link more
Login/Signup to Answer

Question Tools


Asked: 2017-04-30 13:18:10 +0200

Seen: 79 times

Last updated: Apr 30 '17