JohnTravolski
New Member
- Joined
- Nov 25, 2015
- Messages
- 45
- Office Version
- 2019
- Platform
- Windows
I have the following formula applied to an entire column for conditional formatting:
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)
I don't understand why this doesn't work. Can anybody explain?
VBA Code:
=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)
Code:
=IF(T1<>"",T1=OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),-1,0),FALSE)
I don't understand why this doesn't work. Can anybody explain?