Thread: Fill cells based on value
View Single Post
 
Old 11-09-2017, 09:16 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Let's say you have value (7, 3 ot whatever) in A1 then you can use the following formula in Conditional formatting:

=ROWS(G$10:G10)<=$A$1 if you want to start in G10.
In the field Applies to can you write for example =$G$10:$G$100 if your max value in A1 will be 90.

You can use the Format Painter to copy that conditional formatting to another start cell (ensure that the formula has same row number both before and after the colon). Then you can go to the field Applies to and set the reference to what you want.
Reply With Quote