Question: excel if all values are the same then?
Answer: Compare if multiple cells are equal with formulas.
In a blank cell besides your data, please enter this formula: =AND(EXACT(A1:D1,A1)), (A1:D1 indicates the cells that you want to compare, and A1 is the first value in your data range)see screenshot: