如何在Excel中突出显示当月的当前日期 [英] How to highlight current date of current month in excel

问题描述

我插入了大量带有日期的数据..在这组日期列中，我需要突出显示当前日期...


寻找解决方案的步骤是什么?

问候
vivekx2

Hi,
I have inserted large number of data with date..In this set of date column i need to highlight the current date...


What are the steps to find the solution?

Regards
vivekx2

推荐答案

如果您拥有Excel 2010，只需突出显示您的范围，请单击条件格式"，突出显示单元格规则"，然后选择发生数据".您会看到一个对话框，然后可以在下拉菜单中选择今天".您也可以随时建立自己的公式.

If you have Excel 2010 just highlight your range, click on Condition Formatting, Highlight Cells Rules, and choose A Data Occurring. You get a dialog box and you can choose Today in the dropdown. You can always build your own formula as well.

这篇关于如何在Excel中突出显示当月的当前日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！