• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to add cell color based on user input

R

rsdreczko

New Member
I need to color a series of consecutive rows in a table based on the user's input of an integer from 3 to 15. The first row to be colored would be Row(11), with a consecutive number of rows being colored such that the total would equal the the number input by the user. I have tried conditional formatting, but there aren't enough conditions available to accommodate the range needed, and I don't know VBA. Does anyone have any ideas how this can be done?
 
Assumptions:

User input is in cell A2

Select rows 11:25


CF formula is:

=11+$A$2>ROW()
 
You must log in or register to reply here.
Back
Top