Conditional formating specific number of cells based on another cell value

[RedOctoberKnight]

Good Morning,

If possible, I'm trying to conditional format a specific number of cells based on another cell value.

For example, If I have 10 in A1, I want row 1 to conditional format the next cells in the row up to the value in A1. ( so if the value in A1 is 10, I want it to highlight the next 10 cells in the row. If it was 5, highlight the next 5 cells in the row and so on)

Hope this makes sense.

As always, your help is always very much appreciated!

 

[snjpverma]

select cell B1 and go to Conditional Formatting. Go to new rule> use a formula
and put this formula.

=COLUMN()<$A1+2

Then copy B1 and paste the format to other cells where you want the same formatting

	A	B	C	D	E	F	G	H	I	J
1	5	abc	abc	abc	abc	abc	abc	abc	abc	abc
2	7	abc	abc	abc	abc	abc	abc	abc	abc	abc
3	8	abc	abc	abc	abc	abc	abc	abc	abc	abc
4	3	abc	abc	abc	abc	abc	abc	abc	abc	abc

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[RedOctoberKnight]

Perfect! Thank you so much!

 

[snjpverma]

Glad to have helped

 

[Peter_SSs]

Perfect! Thank you so much!

Whilst the suggestion does exactly what you asked, I would be a little wary of relying on it. After applying that CF, suppose that you decide to insert a new column (or columns) at the left of the sheet, or even between column A and column B, say to add some additional information. Immediately on doing that, an incorrect number of columns will be highlighted (try it).

For the layout described, I would suggest the much more robust CF formula of =COLUMNS($B1:B1)<=$A1