Coloring Whole Row. If an order is Past Due the row will turn red. Hello To apply the rule to all your rows delete the data and formatting in rows 1216 to remove the. The trick is to used the to block only the reference of column G. This is called the mixed reference. In the Rules Manager we just have changed the rule to add the dollar in order to colored the whole row.
If an item is Delivered the entire row will be colored in green. This is called the mixed reference. The trick is to used the to block only the reference of column G. If an order is Past Due the row will turn red. Now each row returns TRUE or FALSE only if the value in column G is lower than 10 G2.
This is called the mixed reference.
Naturally the row color will change if. The trick is to used the to block only the reference of column G. Hello To apply the rule to all your rows delete the data and formatting in rows 1216 to remove the. Now each row returns TRUE or FALSE only if the value in column G is lower than 10 G2. This is called the mixed reference. Naturally the row color will change if. In the Rules Manager we just have changed the rule to add the dollar in order to colored the whole row. How to Color the entire row.
