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)
Conditional Format Concatenated Range
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Conditional Format Concatenated Range
Regards,
John
John
-
- Administrator
- Posts: 78494
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional Format Concatenated Range
Use a comma to 'concatenate' the ranges:
=$A$4:$F$100,$H$4:$I$100
=$A$4:$F$100,$H$4:$I$100
Best wishes,
Hans
Hans
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California