Excel consecutive formula

mahmed1

Well-known Member
Joined
Mar 28, 2009
Messages
2,213
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hiya

I have a row of data in cells D3, E3, F3 etc

what i want to do is highlight the values in there to see if the consecutive values are greater than 3 and then highlight it

ie if its 1, 1, 3, 4, 5, 5 (highlighted), 3, 2, 5,5,5 (Highlighted), 5 (Highlighted), 5 (Highlighted), 2,4,4,4 (Highlighted)

so im just trying to highlight all values that exceeda number 3 in my case 3 times in a row , if it dropa back then the count should find the next occurence and highlight until it drops back again

hoping im making sense of it

Im typing from a phone hence why i could highlight the values so have put highligh next to the value
 

mahmed1

Well-known Member
Joined
Mar 28, 2009
Messages
2,213
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Am i ok to bump the thread?
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,118,206
Messages
5,570,889
Members
412,345
Latest member
avelraza
Top