My Digital Quill | Excel Tips and Tricks #23 | How to Create a Chequered or Chessboard Pattern in Excel | Excel Formulas and Functions | Excel #shorts | Excel shortcuts | Excel 365
This simple tip in excel displays a combination of alternating TRUE and FALSE pattern for a selected area in worksheet, resulting in 0s and 1s which can be interpreted in conditional formatting to be a color or no color. The formula combination of four functions to develop this pattern is given below:
=MOD(ROW(),2)=MOD(COLUMN(),2)
You can use this formula to save time and develop chequered or chessboard pattern for your custom designs in Excel. You may also utilize this to develop board games in excel. A smart way to save time and apply customized chequered pattern to your worksheet.
Credits:
Thumbnail Photo by Angela Roma from Pexels
Excel is Fun
• Excel Conditional Formatting for a Ch...
Ajay Anand
• How to Create a Chessboard pattern in...
Kevin Vaughn:
https://www.excelforum.com/excel-form...
Please check out more Excel tips and tricks from the playlist link down below:
• Excel Tips and Tricks
Check this playlist for Excel formulas and functions:
• Excel Formulas and Functions Series
Free Excel Course available on formatting techniques in here:
• Excel Formatting Techniques
🔔 Subscribe for free Office Tutorials at My Digital Quill:
/ @mydigitalquill8945
#howtocreateachequeredpattern #chequeredpattern #chessboardinexcel #conditionalformattinginexcel #checkeredpattern #checkboard #mirrortextinexcel #excelshortcuts #Excelformulasandfunctions #Exceltipsandtricks #Excelshorts #excelmetaverse
#MyDigitalQuill
Watch video #shorts online, duration hours minute second in high quality that is uploaded to the channel My Digital Quill 03 December 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 98 times and liked it 11 visitors.