folks, i am setting a conditional format to highlight where entries are missing in a sheet. I have highlighted range B7 to C66. I want my conditional format to fill where there are blanks in these two columns and a positive value in column L of the same row. My formula for this conditional format is below.
this is a grab of the top few rows in columns B & C.
why does the conditional format only format the cell in col B in the last one?
this is a grab of the top few rows in columns B & C.
why does the conditional format only format the cell in col B in the last one?