• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting

thakur

Member
Hi,

How do I apply conditional formatting using formula. Attaching the spreadsheet. Please advise.

Regards,
K.K.Singh
 

Attachments

  • excel conditional formatting.xls
    15 KB · Views: 2
Hi Thakur,

Select your range C3:C6
Go to Conditional Formatting > Highlight Cell Rules > Greater Than
Put 0 and select the desire format

Same procedure for Less Than
 
Back
Top