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
- Riny_van_Eekelen - you are a genius!!! Works perfectly thankyou so much:)
