Conditional Formatting
Closed
TraceyLongstaff
Posts
1
Registration date
Tuesday October 10, 2017
Status
Member
Last seen
October 10, 2017
-
Oct 10, 2017 at 09:52 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 10, 2017 at 10:21 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 10, 2017 at 10:21 AM
Related:
- Conditional Formatting
- Excel formula to change cell color without conditional formatting - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to clear formatting in excel - Guide
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Phone formatting software for pc - Download - File management
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 10, 2017 at 10:21 AM
Oct 10, 2017 at 10:21 AM
TraceyLongstaff, Good morning.
Suppose your column of dates is A
Select the range of Column A you want; ex: A1:A25
Try to use this formula at your Conditional Formatting Formula:
=AND(TODAY()>A1, B1<>"x")
OK.
Please, tell us if it worked as you want.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose your column of dates is A
Select the range of Column A you want; ex: A1:A25
Try to use this formula at your Conditional Formatting Formula:
=AND(TODAY()>A1, B1<>"x")
OK.
Please, tell us if it worked as you want.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão