lalani123
12-08-2015, 12:12 PM
Hi Experts,
I would like your help to color code a range of cells for each row if more than 4 columns are blank.
Product | Month 1 | Month 2| Month 3| Month 4| Month 5| Month 6
ABC| | | | 500 | 110 | 90
XYZ|10|25||||
DEF|5|||||
UVW|10||||50|
I want to check for each row, if last 4 months (Month 3 to 6) are blank, color code them in a different color. Also, if a longer range is blank that includes the last 4 months, color code them to. For ex. row DEF has empty cells for Month 2 to Month 6, in the case i want to color code month 2 to month 6 and not month 3 to 6.
I would like your help to color code a range of cells for each row if more than 4 columns are blank.
Product | Month 1 | Month 2| Month 3| Month 4| Month 5| Month 6
ABC| | | | 500 | 110 | 90
XYZ|10|25||||
DEF|5|||||
UVW|10||||50|
I want to check for each row, if last 4 months (Month 3 to 6) are blank, color code them in a different color. Also, if a longer range is blank that includes the last 4 months, color code them to. For ex. row DEF has empty cells for Month 2 to Month 6, in the case i want to color code month 2 to month 6 and not month 3 to 6.