# Have a row change co lour when criteria in cells are met.

1. ## Have a row change co lour when criteria in cells are met.

i all
I was wondering if someone out there can help me, I have been trying to solve this for a while without success; I’m sure this problem will be easy for some but unfortunately not for me .

if Date in Column B:B is 300 days past the date nominated in the cell (=+B:B+"300") date is formatted in the cell as dd,mm,yyyy and A:A =”yes”, then that row changes to the colour to red.

A:A B:B D:D E:E
Yes 3/02/2013 ABC/13/00012 30/11/2013
Yes 1/02/2012 ABC/12/00014 27/11/2012
No 2/02/2012 ABC/12/00016 28/11/2012
No 1/04/2013 ABC/13/00013 26/01/2014

I have given a sample and E:E has been placed in only to show the calculation of B:B+300 days.

Cheers
Gatheringinfo

2. ## Re: Have a row change co lour when criteria in cells are met.

Conditional formatting in cell B1
=B1>refdate + 300

where "refdate" is the date your are referencing... Usually a cell value A1 or a named range as shown

3. ## Re: Have a row change co lour when criteria in cells are met.

Hi

Thanks for the quick response, sorry for being so slow still trying to drive this all new to me..
Will give this ago; thanks heaps.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1