Excel Help: Applying Conditional Formatting to Numbers in Percentage format
<p>I am currently trying to apply conditional formatting to certain rows which contain numbers in percentage (e.g. F11 to N11; F14 to N14; F17 to N17 and so on). These are also the only rows in the worksheet that have numbers in percentage. Would like to know what the fastest way to go about doing this is.</p>

<p>Should I:</p>

<p>(i) apply conditional formatting to the whole worksheet to numbers in percentage (if possible) or</p>

<p>(ii) apply conditional formatting to each individual row which is extremely time-consuming?</p>

<p>Appreciate if anyone can help. </p>

<p>Thanks in advance! :)</p>