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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 26, 2014 at 06:36 AM
Related:
- How to format a cell based on date in another cell.
- How to change date format in excel - Guide
- Which example represents cell data with the date format applied to it? - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
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
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
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
