Conditional Format Concatenated Range

[jstevens]

Is it possible to use a concatenated range in one rule for the "applies to" part of the rule? I'm trying to streamline things into one rule.

Example: I have two rules based on the same formula

Rule 1 Formula:=$H4>0 Applies to: =$A$4:$F$100
Rule 2 Formula:=$H4>0 Applies to: =$H$4:$I$100

Streamlined Rule Formula:=$H4>0 Applies to: =$A$4:$F$100&$H4$:$I$100 (This does not work)

[HansV]

Use a comma to 'concatenate' the ranges:

=$A$4:$F$100,$H$4:$I$100

[jstevens]

Thank you Hans!