highlight entire row is first cell is 60 days older than today

**chriscornell** · 03-11-2012, 02:55 PM

Hello,

I cannot figure out how to use conditional formatting to highlight an entire row based on the contents of one of its columns. What happens is that we need to identify everyone that has been joined 45 days ago and 60 days ago. Ideally, their row would highlight yellow (at 45days) and red (at 60 days). Is there any way to do this? I have attached a simple file so you can see what i'm talking about. Thanks!

**Fotis1991** · 03-11-2012, 03:17 PM

Hi and welcome to the forum

Take a look to the example.

Is this what are you looking for?

**chriscornell** · 03-11-2012, 10:25 PM

ah! very nice. i didnt think of adding a column to count the days. i was trying to put that in my condition formula. this is perfect, thanks!

**chriscornell** · 03-11-2012, 10:27 PM

one question... how do i mark this as solved?

**Fotis1991** · 03-12-2012, 03:44 AM

Hi

ah! very nice. i didnt think of adding a column to count the days. i was trying to put that in my condition formula. this is perfect, thanks!

You don't really need the extra column. I just let it to see(and understand) the way of my thought. See the Conditional formatting rules, to understand the formula.

..one question... how do i mark this as solved?

Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.

Hope to helps you.