How can I rewrite the conditional formatting formula to use $A$1:$B$3 into the formula? Cell SH61 should be highlighted.

[arthurz11]

I don't want to write the current formula three times. =ISNUMBER(SEARCH(" " &$A$1&","&$B$1&"-"," "&SH60)), =ISN =ISNUMBER(SEARCH(" " &$A$2&","&$B$2&"-"," "&SH60))UMBER(SEARCH(" " &$A$3&","&$B$3&"-"," "&SH60)). Just one formula so it searches the entire range. My actual data is 150 column and 20 rows. If I can figure out the short version, I should be able to do the rest.

 

[dermie_72]

Remove the $ from the row number:
=ISNUMBER(SEARCH(" " &$A1&","&$B1&"-"," "&SH60))
Then copy the formula down and it will automatically increment the row.

 

[arthurz11]

Remove the $ from the row number:
=ISNUMBER(SEARCH(" " &$A1&","&$B1&"-"," "&SH60))
Then copy the formula down and it will automatically increment the row.

I was trying to edit but my time expired. So here it is Data is A1 is -20,B1 is 0, A2 is -19,B2 is -1, and A3 is -18, B3 is -1. This is a Conditional Formatting formula. =ISNUMBER(SEARCH(" " &$A1&","&$B1&"-"," "&SH60)). By the way this works just for on row. I don't want to write it three times in the Conditional Formatting formula. Just one which I can use A1:B3

 

[Fluff]

Duplicate to: How do I revised this Conditional Formula to read the Cell's location instead of the values? =ISNUMBER(SEARCH(" -20,0-"," "&SH60))

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.