Рет қаралды 30,868
✅ Get the sample Excel file to follow along: www.contexture...
In Excel, you can use the conditional formatting to highlight one or more cells, based on rules. In this example, winning lottery numbers are entered on a worksheet. The numbers from our purchased tickets are also on the worksheet. A conditional formatting rule is set up, to colour the cells where the ticket numbers are found in the list of winning numbers. This formatting makes it much easier to check our tickets, and see how many winning numbers we have.
⏰ Video Timeline ⏰
00:00 Worksheet Setup
00:21 Manually Check the Numbers
00:30 Start the Conditional Formatting
00:52 Set the Conditional Formatting Rule
02:14 Refer to active cell
02:48 Select the Formatting
03:04 See the highlighted winning numbers
03:15 Get the Sample File
✅ Excel resources I recommend ► myctx.link/xlpick
Instructor: Debra Dalgleish, Contextures Inc.
More Excel Tips and Tutorials: www.contextures...
Subscribe to Contextures KZfaq: www.youtube.co...
#ContexturesExcelTips