• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 34
  • Last Modified:

Applying/Expanding Conditional Formatting to multiple cells

I have the following formula which generates a red background in cell H5 and J5:

=NOT(IF(P5="B",IF(OR(ISNUMBER(SEARCH("A",H5)),ISNUMBER(SEARCH("T",H5)))*AND(J5>1),CEILING(SUM(C5-B5),"0:15"),),"0:00"))

How do I apply the same Conditional Formatting logic to cells G5, J5, I7, J7...etc.
0
Bill Golden
Asked:
Bill Golden
  • 2
1 Solution
 
Roy CoxGroup Finance ManagerCommented:
Just change the refers to in the Conditional formatting wizard to the range that you want. If you want it to expand you need a dynamic named range
0
 
Bill GoldenExecutive Managing MemberAuthor Commented:
Thanks Roy. I got it to work almost immediately. (Had to remember to place a comma between the ranges.)
0
 
Roy CoxGroup Finance ManagerCommented:
Pleased to help. Of course, remember if your data is formatted as a Table then the Conditional Formatting will expand automatically.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now