moppyau
New member
- Joined
- May 6, 2013
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Location
- Australia
- Excel Version(s)
- Excel2013
Hi All,
I have a spreadsheet using Office 2007 that is conditionally formatted depending on cell value. Is it possible to use a formula to count the highest number of consecutive cells across a row with the same font color, blue in my case. I have attached a small sample of my data. Thank-you in advance.
Moppy
I have a spreadsheet using Office 2007 that is conditionally formatted depending on cell value. Is it possible to use a formula to count the highest number of consecutive cells across a row with the same font color, blue in my case. I have attached a small sample of my data. Thank-you in advance.
Moppy