Traditional Culture Encyclopedia - Almanac inquiry - How to display the date in other colors when excel makes a perpetual calendar?
How to display the date in other colors when excel makes a perpetual calendar?
Select the cell on 1 day (such as A 1), select Format-Conditional Format on the menu bar, select the formula in Condition 1, enter =A 1=TODAY () next to it, and then click Format to select the required content.
Supplement: How to set it up? I've tried many times, no problem. Why didn't you say hello to me? By the way, what is the format of your "perpetual calendar" date? I said the standard date format, such as "2009-11-1".
- Previous article:Academic fortune-telling of Lao Huangli
- Next article:20 19 calendar for men and women
- Related articles
- Maternity calendar 2020
- Dreaming of a wedding photo.
- What does God think of "fortune telling"
- Is it appropriate to pick up the car on February 29, 2022?
- July 24, 2020 Gregorian calendar
- Guo Chao's painting materials-Want to learn how Guo Chao's illustrations start from scratch?
- Zodiac calendar
- 10 October 17 when?
- What is the standard to distinguish a person from a good person or a bad person?
- China Zodiac Calendar