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<>"")
For example if this was on cell A1 I want it to read B1.
A1 is currently green.
If there is a date in B1 I want A1 to go white.
Let's say you want to apply this to F11:K11.
Select this range. F11 should be the active cell in the selection.
Create a conditional formatting rule of type "Use a formula to determine which cells to format", with formula
=F12<>""
This is the condition for the active cell F11. Excel will automatically adjust it for the other cells in the selection.
- Will this work for every cell to read the corresponding one below it or will they all just read the F11 cell?
F11 will look at F12, G11 will look at G12, etc.
- I must be doing something wrong.
This is the formula I am using on row 55 but it is registering the cell underneath it as well as F56 being a overriding cell that clears the entire row.
=F56<>NOT(ISBLANK($F$56:$K$56))