Forum Discussion
Conditional formatting with multiple conditions not working
Paula2325 So I assume you are applying this format to a range in column D. You have a couple problems. 1st, to refer to an entire column you need a ":" in between so it would look like $D:$D. BUT 2nd and more important you don't want to refer to the entire column (at least I don't think that is what you are trying to do). conditional formatting looks at the upper left cell of the range you are applying it to and evaluates the formula and then moves cell to cell and adjusts the formula accordingly. What that means is you only want to write the formula as if you are ONLY interested in the upper left cell of the range.
So if your range is $D:$D (the entire column of D) then D1 is the upper left and the formula you want is:
=AND($D1="",$I1="Community")
Please NOTE that I did NOT use "$" before the row #s, because you want Excel to increment D1 to D2 to D3, etc... as it goes down the column.
Lastly, to check if the cell is blank you could use ISBLANK($D1) but the problem with that or the above ="" is that sometimes people like to "clear"/"erase" a cell by hitting <space><enter> which really doesn't make it blank but rather =" " (have a space character in it). If you want to ignore spaces and accept blank looking cells as blank, then you can use TRIM($D1)=""