I'm looking to gray out specific cells based on an adjacent cell value.
see attached example, i'll explain below too.
Column B3 = 6
I have 2 groups of 24 columns G:AD & AF:BC
each column has a # (1-24) in row 2
so i'm looking to gray out the cells that are greater than the # in column B.
B3 = 6
would gray out cells M3:AD3 (#'s 7-24) & cells AL3:BC3 (#'s 7-24)
see image below too. i manually grayed out the cell to what they should look like based on the value in column B
Capture.PNG
Bookmarks