I have some columns where I have done a =TODAY()-14, TODAY()-7, TODAY() gradated red-yellow-white scale (column D) to show how long ago something was received or requested.
This is working fine.
I have also selected column D to conditionally format as WHITE FILL (so it looks blank) if column E is NOT BLANK. (The idea being that if I have data/text in column E, the work has been actioned, so the item in D is not longer outstanding and does not need to be red/yellow).
This is working fine on THIS selection. As you can see the single dot (as a test) in column E has turned item in D (23/09/2020) which was the previously red, white.
I used the following formula on column D, as well as the gradated red-yellow urgency scale.
HERE IS THE PROBLEM.
Further along in the worksheet, I want to do the same thing with columns T and W.
Here is the formula I'm using on column T (as well as the colour scale as before).
So why is column T not going white when there is data in column W, as it worked on the previous selected.
I have a feeling it's about conflicting formatting, but why is it working once, but not again?
I'm no pro whatsoever, so please explain simply
Thank you
This is working fine.
I have also selected column D to conditionally format as WHITE FILL (so it looks blank) if column E is NOT BLANK. (The idea being that if I have data/text in column E, the work has been actioned, so the item in D is not longer outstanding and does not need to be red/yellow).
This is working fine on THIS selection. As you can see the single dot (as a test) in column E has turned item in D (23/09/2020) which was the previously red, white.
I used the following formula on column D, as well as the gradated red-yellow urgency scale.
HERE IS THE PROBLEM.
Further along in the worksheet, I want to do the same thing with columns T and W.
Here is the formula I'm using on column T (as well as the colour scale as before).
So why is column T not going white when there is data in column W, as it worked on the previous selected.
I have a feeling it's about conflicting formatting, but why is it working once, but not again?
I'm no pro whatsoever, so please explain simply
Thank you