Forum Discussion
Solved
Conditional Formatting Formula Needed
Hi members - I was wondering if someone could help me with what should be an easy formula. I need a formula in conditional formatting to highlight in red if there is more than 6 consecutive cells in ...
Muffinman Perhaps the example in the attached workbook does what have in mind.
Muffinman Perhaps the example in the attached workbook does what have in mind.
Riny - was playing around with this and when i apply it to multiple rows it totals all ''regulated work'' and highlights entire sheet when it finds more than 6. How can i isolate this formula to only calculate regulated work >6 by occurrences in a row only? The only way i can get it to do a row only calculation (and only highlight when it finds >6 in that row) is to apply to one row only then duplicate formula apply to the next row and then change the row number and repeat this process for all rows. I would show a screenshot to make it easier to understand but cant seem to get it approved through the editor on this site