yes i have tried to use this system (i also tried to use this format to and the single quote into the cell but that caused a circular ref).How can this formula be put into a conditional format so it checks each cell by its only reference?