Skip to main content

CONDITIONAL FORMATTING IN EXCEL

Image
Posted by

इसके लिए आपको Home tab में जाकर Conditional Formatting option पर क्लिक करके New rule पर क्लिक करना होगा। 

उसके बाद New Rule वाले dialog box में  Use formula to determine which cells to format पर क्लिक करना होगा। 

उसके बाद Formula waale box mein cursor रखिए और फार्मूला टाइप कीजिये =MOD(ROW(),2)=1 to highlight rows और =MOD(COLUMN(),2)=1 to highlight columns.

यह रही प्रैक्टिस फाइल की लिंक डाउनलोड करके प्रैक्टिस कीजिए।

 Conditional formatting in excel practice file

Labels:

Comments

Post a Comment

Popular posts from this blog

Auto save in OneDrive and Google Drive

Posted by
 When you save a word document, PowerPoint presentation or Excel workbook in OneDrive the Auto save feature turns on and you don't need to worry about losing you progress in a file. Basically your document is saved in the cloud and you can access the file from anywhere. Google Drive also has a feature for Autosave when you create any file in docs, sheets, slides, forms,drawings, sites and jamboard these files are automatically saved which means you won't need a "save" button to save your work. NOTE:- When you create a file in Word on the web, PowerPoint on the web or Excel on the web in www.office.com  it is automatically saved in OneDrive and you don't have to do anything.
Post a Comment
Read more