Forum Discussion
Conditional formatting
Hi Everyone, First timer here. I am building some spreadsheets and I am having some issues with conditional formatting. The sheet contains results from laboratory water testing and results are ofte...
Assuming the first number is in the cell A2 and last number is in the cell C12, then select the range A2:C12 and make a New Rule for Conditional Formatting using the formula given below and set the format as per your choice.
=AND(ISNUMBER(A2),A2>10)Remember to replace A2 with the first cell of whatever is your data range .