I have this formula to apply conditional formatting to a cell in a range if the previous two cells in the row are blank.
=AND(WEEKNUM(TODAY())=RIGHT(D$2,2),ISBLANK(B3),ISBLANK(C3))
The range is this
=$D$3:$AL$27
Row two has the week number. The cell fill should be red if the two previous cells are blank (no data entered for the previous two weeks). This formula does not seem to do this.
No comments:
Post a Comment