In most cases,when manually creating a conditional formatting formula,the formula should use $\underline {\text { absolute } }$references and point to the first row of data in a table._________________________

Question

Quizplus · Accepted Answer

When creating a conditional formatting formula, relative references are often used to apply the formatting to each cell in the range based on its own value, rather than using absolute references which would fix the reference to a specific cell.

In Most Cases,when Manually Creating a Conditional Formatting Formula,the Formula absolute ‾\underline {\text { absolute } } absolute ​

In Most Cases,when Manually Creating a Conditional Formatting Formula,the Formula $\underline {\text { absolute } }$