Conditional Formatting

Closed
Dee - Oct 18, 2011 at 06:49 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 19, 2011 at 05:29 PM
Hello,


I am trying to design an excel spread sheet where basically i track invoices which are paid and outstanding.

In Row A - Date of the invoice
Row B - Invoice number
Row C - Customer
Row D - Invoice Value
Row E - Due Date
Row F - Paid $
Row G - Date Paid.

I have worked out how to conidionally format the date that anything 7days or older will conditionally format to Red which is fine I have used =TODAY()-E5>7
But now I want to add a format in that if there is an amount put in Row F (paid) or Row G (Date paid) which ever is easiest the ENTIRE LINE will change to Green so at a glance I know the invoice is no longer outstanding.

Can someone please let me know the best way to go about doing this and if i should alter the first format which I have put in.
Any help would be great.
Thanks :) :)

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 19, 2011 at 06:50 AM
1. Select cell A2
2. Do control + A to select all rows
3. Go to conditional format and enter
=OR($F2<>"",$G2<>"") and your green color
4. select cell E2
5. click on E column
6. Go to conditional format. Leave the first conditional format alone ( the one for the green) and add a new format as condition #2
=AND(E2<>"",today()-e2>7) and select red color
Hi I have tried doing this exactly as you have said and it is still no working. None of the colours appear to change at all.?
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 19, 2011 at 05:29 PM
Post at some share site a sample book with the conditional format that added. You would need to post back the link to the file back here