Managing the editing of Conditional Formatting

[Roncondor]

I have a lot of different sections that need to be conditionally formatted

for instance I have a lot of different rows that need to be formatted depending on what is in row 2

However, when you go to edit in the box it looks like this
=$E$135:$N$135,$E$143:$N$143,$E$77:$N$77,$E$137:$J$137,$E$148:$N$149,$E$125:$N$127,$E$131:$N$131, ....

When I have so many of them, you can not even see them in the edit box

is there an easier way?

Thanks RK

 

[Joe4]

Not that I can think of.
If there was some sort of "pattern" as to which cells it should apply to (i.e. every 4th row, etc), we might be able to build it right into the Conditional Formatting formula.

For example, let's say that you wanted to apply some conditional format to cells A1, A5, A9, A13, A17, and A21(every fourth cell in column A), instead of selecting each range individual, you select A1:A21 and write the Conditional Formatting formula in this format:
=AND(MOD(ROW(),4)=1,original condition)

 

[Roncondor]

Not that I can think of.
If there was some sort of "pattern" as to which cells it should apply to (i.e. every 4th row, etc), we might be able to build it right into the Conditional Formatting formula.

For example, let's say that you wanted to apply some conditional format to cells A1, A5, A9, A13, A17, and A21(every fourth cell in column A), instead of selecting each range individual, you select A1:A21 and write the Conditional Formatting formula in this format:
=AND(MOD(ROW(),4)=1,original condition)

Thanks - there is no pattern. You would think Microsoft would create a way to do this [On the other hand, I would not think so!]

 

[Joe4]

You would think Microsoft would create a way to do this [On the other hand, I would not think so!]

Your situation isn't really typical of how one would expect Conditional Formatting to be applied.
More often than not, each CF rule it is being applied to a single range, and not a whole bunch of small random ranges.

 

[Fazza]

suggest you set up a worksheet that has data defining which ranges have what conditional formatting
and then VBA to loop through & apply it (probably after deleting all conditional formatting first)
maybe also if there is a large amount of conditional formatting, delete it when not needed & apply on a need-to-see basis

FWIW, conditional formatting was easier to control in Excel 2003 and complexity has been added in newer versions. the way it was done has made managing it more difficult