Assume you have a table in Excel sheet and in E column you have integer values (starting with E2. What happens if new conditional formatting rule = $E2 > 10 is applied?
1
All cells with a value greater than 10 will be highlighted
2
Rows in the table will be highlighted if the data value in column E is greater than 10
3
Table rows will be hidden if the data value in E column is greater than 10
4
Columns with values greater than 10 will be highlighted