Forum Discussion
Not is blank formula not working
So let's say the Target dates are in F55:K55, the Revised dates in F56:K56 and the Actual dates in F57:K57.
Select F55:K56 (2 rows by 6 columns). F55 should be the active cell in the selection.
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=F56<>""
Click Format...
Activate the Fill tab.
Select white as highlight color.
Click OK, then click OK again.P.S. If you only want to color a cell white if it contains a date and the cell below it also contains a date, use the following formula instead:
=AND(F55:F56<>"")
So the spreadsheet is used to track dates for projects. I currently have it set up so that conditional formatting reads the date and changes it red/green/yellow depending on how close it is.
Underneath that I have a revised date box.
The function I need the formula to perform is that when the revised date box has the date added I want the target date box above it to go white instead of red/green/yellow.
There are six cells in each row and I need them to read their corresponding revised date cell without having to format each cell independently.
I then want the same thing to happen with the revised and the actual boxes but will format that row separately.
So let's say the Target dates are in F55:K55, the Revised dates in F56:K56 and the Actual dates in F57:K57.
Select F55:K56 (2 rows by 6 columns). F55 should be the active cell in the selection.
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
=F56<>""
Click Format...
Activate the Fill tab.
Select white as highlight color.
Click OK, then click OK again.
P.S. If you only want to color a cell white if it contains a date and the cell below it also contains a date, use the following formula instead:
=AND(F55:F56<>"")