Oct 03 2022 01:43 PM
I'm afraid that's not specific enough. Could you explain in detail what you want to do?
Oct 03 2022 01:49 PM
I am wanting to set up a conditional format that if cell A1 says "yes" then the selected cells that contain a date will replace the date with an "x". However if cell A1 says "no", then nothing is changed in the selected cells.
Oct 03 2022 01:54 PM
SolutionThank you.
Select the cells that you want to format.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=$A$1="yes"
Click Format...
Activate the Number tab.
Select Custom in the Category list.
Enter "x" (including the quotes!) in the Type box.
Click OK, then click OK again.
Mar 09 2023 08:22 PM
Mar 10 2023 12:33 AM
It would have been better to ask your question in a new discussion, since it has nothing to do with this one.
=MAX(DAYS(B119,TODAY()),0)
Oct 03 2022 01:54 PM
SolutionThank you.
Select the cells that you want to format.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=$A$1="yes"
Click Format...
Activate the Number tab.
Select Custom in the Category list.
Enter "x" (including the quotes!) in the Type box.
Click OK, then click OK again.