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.
- Excel date format dd.mm.yyyy - Guide
- How to change account based in instagram - Instagram Forum
- If cell contains date then return value ✓ - Office Software Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- An example of a cell is a blank cell ✓ - Programming 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
