Excel Formula for Conditional Formatting of Dates
Closed
MRF14B
-
20 Jan 2017 à 10:17
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 20 Jan 2017 à 12:26
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 20 Jan 2017 à 12:26
Related:
- Excel Formula for Conditional Formatting of Dates
- Excel clear formatting - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Conditional formatting excel dates - Guide
- Grade formula in excel marksheet - Guide
- Formula bar in excel - Guide
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
20 Jan 2017 à 12:26
20 Jan 2017 à 12:26
MRF14B, Godd afternoon.
Try to do:
Select A1
Conditional Format Menu
Using formula
=AND(TODAY()-A1>30, B1="")
Format fill colour as you desire.
OK.
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to do:
Select A1
Conditional Format Menu
Using formula
=AND(TODAY()-A1>30, B1="")
Format fill colour as you desire.
OK.
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
