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
- If cell contains date then return value ✓ - Office Software Forum
- Based on the values in cells b77 ✓ - Excel Forum
- Format factory - Download - Other
- Clear only the formatting from the selected cell (leaving the content) - Guide
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