Adding 1 to Every Number in Formula String

[mba3170]

Hi All,

I am working on many workbooks and for all of them, I am using conditional formatting for hundreds of cells. Specifically, I am using 7 different cell ranges, and the cells themselves are always one cell apart. For example, this is for one of the ranges (with hundreds more references in this range and in each range):

B$4:AS$4,B$9:AS$9,B$14:AS$14,B$19:AS$19

Is there a formula I can use to add +1 to every number, so I don't have to do it manually? I can't find an answer anywhere. Here is what I would need:

B$5:AS$5,B$10:AS$10,B$15:AS$15,B$20:AS$20

Thank you for the help.

 

[Sektor]

You just need to modify a string? It's not clear, but you could use INDIRECT formula or some VBA.

 

[awoohaw]

Use cursor to highlight your ranges. In the cell the cursor is in type "=" and arrow up one cell, then type "+1" then CNTL-ENTER.
(actually you can highlight all the blank cells that you want to update at one time)