Thank you so very much for the help I understand. since I am a novice at excel can you guide me to perform this function please. I have tried to insert the formula above into the conditional formatting pop up window but nothing is happening. Really Really appreciate the help.