Conditional Formatting Question

Hi

In my invoice log I have a Due Date column which is calculated by taking the date from another cell in the row (Invoice Date) and adding the value of another cell in the row to it, to give me a calculated Due Date, e.g:

=SUM(A31+E31)

I then have a conditional formatting rule on this Due Date column which changes the colour to red, if the Due Date is less than TODAY(), which highlights it is Overdue.

What I really need is for my Status column (which is a drop down menu containing values for Paid, Credit, Overdue, Sent) to be automatically changed to Overdue rather than the conditional format rule to change a colour to red (which is just a temporary fix to until i resolve this question!)

Is it possible a conditional format rule can change a value rather than a colour!? My conditional format rule is:

=AND($N22 < > "Paid",$H22 < TODAY())

Any ideas on how I can achieve this would be massively appreciated.

Thanks in advance.

Conditional Formatting doesn't change anything except color.
Changing value is not formatting

Originally Posted by sandy666

Conditional Formatting doesn't change anything except color.
Changing value is not formatting

Thanks for the update.

Do you have a suggestion, or simple function I could add to my worksheet that would change the Status value to 'Overdue' if a date in one cell is less than todays date?

What is the hell?!
You are not allowed to access the requested page
==

try to create something like: IF ( A1 < TODAY() , "Overdue" , "Stat" )

Originally Posted by sandy666

What is the hell?!
You are not allowed to access the requested page
==

You've lost me. But thanks anyway.

It was not info for you

It was about sucuri server which not allow me to send formula just for you

sorry about that

Originally Posted by Special-K

This forum is reading your reply as HTML, put spaces around < > characters

I know, but most of the time I can use standard formula with < or > or <> and nothing happen
Also if wrap [ formula ] is used I can send formula with these things.
Suddenly I got message as above.