Hey Excel Community,
I have a blank table
Capture.JPG
And want to make it look like this:
Capture2.JPG
Explanation:
Every cell that is empty is colored red except when the column Type is Ground, then it should be greyed out whenever it is empty.
I tried doing this by making a macro which was easy (dax filter and then color) but via conditional formatting (which is my goal here), I dont find a solution.
Is there a way I can use a formula like
IF(AND(ISEMPTY(Currentcell), ColumnB="Ground"), then:GREY, (else:) IF(ISEMPTY(Currentcell), then:RED)
In the conditional formatting formula?
Thanks for your help,
hope my question is clear.
Cheers,
Janik
Bookmarks