Forum Discussion
Color coding cells based on values
Hi, I have 7 columns and 50 rows of data . Data value in cell can range from 1 to 35. For example First row can hold value like 4, 19, 20, 23, 29, 33, 35. Similarly there will be 50 rows of dat...
Try applying a conditional formatting with a color scale rule. Then you'll see similar color patterns in those rows; I'm still wondering how you'll check similarities, just checking the color by sight?