How to format a cell based on date in another cell.

Closed
Abhi - Dec 26, 2014 at 05:22 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 26, 2014 at 06:36 AM
Hello,

i.e. We want to format B1 based on date in A1. ( If date in B1 is 2 or more days higher from the date in A1, then B1 must get colored. This is to be applied on all corresponding cells of column A and B of the entire table.

Some one kindly suggest some solution.


1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Dec 26, 2014 at 06:36 AM
Abhi, Good Morning.

Use Conditional Formatting.
Select B column
Go Menu Conditional Format
New Rule --> Using formula
Formula --> =B1-A1>1
Select Format Fill RED color
OK

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0