Highlight Row above an already highlighted row or...

Jeffrey Green

Well-known Member
i have 100,000 with about 15,000 lines that highlighted because there is a TRUE in and AND formula in the row.
I just filtered for TRUE< then highlighted in Yellow fill.

Now they want me to highlight the row immediately before the TRUE.

I can't seem to replicate my AND formula . .

thanks
 

Joe4

MrExcel MVP, Junior Admin
What column is TRUE in?
Let's say it is column Z.
Then, select rows 2 down to the last row, and enter this Conditional Formatting formula:
=$Z1=TRUE
and select the yellow highlighting option.

If you want BOTH the row with TRUE and the row before it highlighted, the formula should be:
=OR($Z1=TRUE,$Z2=TRUE)
 

Some videos you may like

This Week's Hot Topics

Top