Conditional formatting based on date

[ARossi]

Hi all. I have a spreadsheet that tracks user reviews for books I send them. See below for example. If the person reviewed a book, but it was reviewed more than 30 days after it was sent, I'd like to format a cell blue. I know this can't be difficult but I can't figure it out. Can you help? TIA!

	A	B	C
1		SENT	REVIEWED
2	PERSON 1	1/11/15	1/13/15
3	PERSON 2	1/11/15	5/25/15
4	PERSON 3	1/11/16

<tbody>
</tbody>

 

[bbott]

Welcome to the board.

Your conditional formatting formula in C2 would be:

=C2-30 > B2

Use the format painter to copy the format down.

 

[ARossi]

Perfect, thank you!!

And thanks for the welcome!

 

[bbott]

Perfect, thank you!!

And thanks for the welcome!

You're welcome.