CODEWITHSUNDEEP
excelexcel-formulaconditional-formatting
charles082986
charles082986

Reputation: 181

Excel Conditional Formatting by Formula isn't applying correct styles

I have a formula used for conditional formatting:

=OR(ISNUMBER(FIND(Primary,INDIRECT(ADDRESS(ROW(),2)))),ISNUMBER(FIND(Secondary,INDIRECT(ADDRESS(ROW(),2)))),INDIRECT(ADDRESS(ROW(),2))="ALL")

The formula is intended to highlight a cell if a value in the "B" column matches the value in the Primary field, the Secondary field, or is set to "ALL".

When pasted into any cell in a row, it returns the appropriate TRUE or FALSE value, however when used as a formula for conditional formatting, no cells receive any formatting.

Upvotes: 0

Views: 67

Answers (1)

Scott Craner
Scott Craner

Reputation: 152660

get rid of the indirect and ROW():

=OR(ISNUMBER(FIND(Primary,$B1)),ISNUMBER(FIND(Secondary,$B1)),$B1="ALL")

Make the sure the row refers to the first row in the Applies to: range. So in this it is expeted that you are using full column reference or that the range starts on row 1.

If it is different then change the 1s to the first row in the applies to range.

Upvotes: 1

Related Questions