Hi,
Is it possible to have a cell highlighted but only when a value above it as appeared for the 5th time. As per the image I want to be able to have P1 highlighted but only after it as appeared 5 times,
and then for the sequence to carry on down the column as more data gets added. Is it also possible to apply this to more data in the same column ( I.E P3 ) in the image, at the same time ?
Any help would be much appreciated.
Thank you
Is it possible to have a cell highlighted but only when a value above it as appeared for the 5th time. As per the image I want to be able to have P1 highlighted but only after it as appeared 5 times,
and then for the sequence to carry on down the column as more data gets added. Is it also possible to apply this to more data in the same column ( I.E P3 ) in the image, at the same time ?
Any help would be much appreciated.
Thank you