Conditional Formatting to Highlight Cell when Previous Cell was Identical

[JohnTravolski]

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 where the cell is blank. Unfortunately, it does:


I tried using this formula, but it doesn't work at all (no cells end up highlighted)

=IF(T1<>"",T1=OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),-1,0),FALSE)

I don't understand why this doesn't work. Can anybody explain?

 

[mart37]

Seems okay. Are you sure the cells are empty? Do you have more Cf-rules?

 

[Saba Sabaratnam]

You could the following formula to format your cells.

=AND(ISBLANK(A1)=FALSE,A1=A2)

Kind regards


Saba

 

[Fluff]

How about

=AND(T1<>"",T1=OFFSET(T1,-1,0))