Hi,
There is a similar post that deals with this problem for Vertical cells, but I didn't understand the solution well enough to convert for Horizontal data.
My data is arranged as follows:
I want to:
Highlight the blank cells that occur for multiple columns across.
But Ignore blank cells that only occur once horizontally. e.g. R6, or O7
The highlighted cells above are an example of the cells I want to be formatted.
Original post here:
There is a similar post that deals with this problem for Vertical cells, but I didn't understand the solution well enough to convert for Horizontal data.
My data is arranged as follows:
I want to:
Highlight the blank cells that occur for multiple columns across.
But Ignore blank cells that only occur once horizontally. e.g. R6, or O7
The highlighted cells above are an example of the cells I want to be formatted.
Original post here:
Conditional Formatting to Highlight Cell when Previous Cell was Identical
I have the following formula applied to an entire column for conditional formatting: =T1=OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),-1,0) This highlights a cell when the previous cell had the same value. Example: This is the behavior I want, except I don't want it to work in the situation...
www.mrexcel.com