00:00If you have been tasked to change your coloring format on your dataset table, do not do one cell
00:04at a time like this. This is very time-consuming and laborious. Let me show you how you can do it
00:09in one go. Place your cursor in your dataset table, press Ctrl A, Ctrl H to open up Find and Replace.
00:14On the first format here, you're going to click on Fill, and then you're going to select the color
00:18that you want to replace, which is Yellow, and click OK. On the second format here, this is what
00:22you're going to replace with. I'm going to replace it with Cyan, OK, and Replace All. This will
00:26replace all the yellow highlights or fill with Cyan. Now, to replace, let's say for example,
00:32this orange font to a bold red, what you do is this. Make sure you select everything with
00:37Ctrl A, Ctrl H if you have not have your Find and Replace open. Click on Format here, go to Font,
00:42we're going to replace the orange, OK, with red and bold, like this, and click OK, and Replace All.
00:52And that will do all the replace in one single go.
Comments