CF a Row based on previous row.
 

I have a range of data A45:L112
I need to CF any row in that range to have a White Font (Hide from
view) if the data in the row directly above it is identical. I tried
setting the Expression =$A46=$A45 but that did not work.

CF a Row based on previous row.
 

Did you try it in FORMULA IS instead of cell value is

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gtslabs" wrote in message
...
I have a range of data A45:L112
I need to CF any row in that range to have a White Font (Hide from
view) if the data in the row directly above it is identical. I tried
setting the Expression =$A46=$A45 but that did not work.

CF a Row based on previous row.
 

On Dec 2, 9:11*am, "Don Guillett" wrote:
Did you try it in FORMULA IS instead of cell value is

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"gtslabs" wrote in message

...



I have a range of data A45:L112
I need to CF any row in that range to have a White Font (Hide from
view) if the data in the row directly above it is identical. *I tried
setting the Expression =$A46=$A45 but that did not work.- Hide quoted text -

- Show quoted text -

Yes, I am selecting a range A95 to L95 and using the CF on a Formula
=$A95=$A94