Conditional Formatting not working.

**EquityTrader** · 06-10-2014, 10:22 AM

Hello everyone. Long time reader, first time poster. Excel 2010.

I have a Conditional format that is not working. The CF is located in O60:O63. My formula for the Condition is:

=OR(INDIRECT(SUBSTITUTE(SUBSTITUTE(ADDRESS(ROW(),COLUMN()),"$",""),ROW(),"")&IF(COUNTA($A:$A)<32,7,MAX($C$21+16,59)))="Part Rate (%)",INDIRECT(SUBSTITUTE(SUBSTITUTE(ADDRESS(ROW(),COLUMN()),"$",""),ROW(),"")&IF(COUNTA($A:$A)<32,7,MAX($C$21+16,59)))="Perf Weight (%)")

Basically saying if the title of my column (it moves-hence the formula) is equal to "Part Rate (%)" or "Perf Weight (%)" then make it Red and format it as a percentage. Neither format changes. If I copy paste the formula itself into the cell, it says TRUE (I pasted the formula itself into O63 as an example).

These cells were copy/pasted from Columns to the right starting at row 7. I need them to format based on the title of the column. The row of the column varies.

TIA.

**ChemistB** · 06-10-2014, 10:33 AM

You should be able to select your entire range, i.e. B60:O63
Conditional Formatting> Use Formula
=OR(B$59= "Perf Weight (%)", B$59="Part Rate (%)")

If any of the column headers in row 59 are either of those, you'll get your red font.

**EquityTrader** · 06-10-2014, 12:50 PM

My column header row moves. I cannot do Row 59. It can be anywhere from row 7 down. That is why I have that formula. Basically, it starts at row 7, then moves to another row that is Row 59 or greater, and all the following rows are conditioned against that.