Hello Guys, I have made an excel file where when you enter any value in the cell it turns red and it remains normal when the value is coming from formula. I have used conditional formatting =NOT(ISFORMULA(A1)). But now, when I am done working on the file and want to send it to others, I can not send the file with formula to them. So I have to copy the cells and paste it in value but this makes all the cells red because of conditional formatting. Any solution to this? I can not make a new file and copy paste it because its a very huge file.