CF a Row based on previous row.

  • Thread starter Thread starter gtslabs
  • Start date Start date
G

gtslabs

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.
 
Did you try it in FORMULA IS instead of cell value is

--
Don Guillett
Microsoft MVP Excel
SalesAid Software





- Show quoted text -
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting on a dynamic range - workaround 1
Vlookup using a dropdwn list, check different tables based on drop 2
Conditional formatting 2
Selective Copy from other excel file, sort, then deleteon a condition 1
Selecting rows. 3
CF Row after CF applied to Column 4
Delete rows where 1st 3 characters in a cell DO NOT meet criteria 5
Delete rows where 1st 3 characters in string don't match criteria 2

Back
Top