satyavati0120
New Member
Hi,
Please find below the snapshot of my excel sheet & description:
I am trying to highlight the values in column F, into 3 colours (based on the value of cell D7).
They should be highlighted in one colour until their sum is <=85 , then the next consecutive cells in column F should be highlighted in other colour until the sum <=85 & so on.
I have manually highlighted the cells in column F just to show what the formula should do.
Please can someone advise the conditional format formula I should use on column F to get these multiple colour highlights? Not able to make it happen.
I have also attached the excel file for reference.
Please find below the snapshot of my excel sheet & description:
I am trying to highlight the values in column F, into 3 colours (based on the value of cell D7).
They should be highlighted in one colour until their sum is <=85 , then the next consecutive cells in column F should be highlighted in other colour until the sum <=85 & so on.
I have manually highlighted the cells in column F just to show what the formula should do.
Please can someone advise the conditional format formula I should use on column F to get these multiple colour highlights? Not able to make it happen.
I have also attached the excel file for reference.