What conditional formatting rule is needed to highlight the entire table row for all sales values greater than 10?
=$B2>10
=B1>10
=A$1>10
=B$2>10
Expert Answer
Solution : Option : A :
The correct conditional formating to get the desired result is option A : =$B2>10