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
0
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.?
0
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
0