Reply to thread

Message: <blockquote data-quote="*danushka*" data-source="post: 30557865" data-attributes="member: 54015">To highlight values greater than 200 in Excel, you can use Conditional Formatting. Here’s how:<ol> <li data-xf-list-type="ol">Select the range of cells where you want to apply the formatting.</li> <li data-xf-list-type="ol">Go to the Home tab on the ribbon.</li> <li data-xf-list-type="ol">Click on Conditional Formatting > New Rule.</li> <li data-xf-list-type="ol">Choose Format cells that contain.</li> <li data-xf-list-type="ol">In the drop-down menu, select Cell Value and then greater than.</li> <li data-xf-list-type="ol">In the box next to it, enter 200.</li> <li data-xf-list-type="ol">Click on the Format button, choose the formatting style you prefer (like changing the background color), and click OK.</li> <li data-xf-list-type="ol">Click OK again to apply the rule.</li> </ol>Now, any value greater than 200 will be highlighted in the style you selected.</blockquote>

Top Bottom