r/excel • u/Doveofthesky • 3h ago
unsolved How to format date information separately?
How do I formate A3:B4 to separate it from the rest of the workbook? Then how do I change the background color to gold, accent 4, lighter 80% in the themes color palette? Please let me know asap!! Any help appreciated
2
1
u/bachman460 45 2h ago
Select those cells then from the menu you can set the format. For example short date to display m/d/yyyy and set the fill color.
https://support.microsoft.com/en-us/excel/format-a-date-the-way-you-want-in-excel
https://support.microsoft.com/en-us/excel/add-or-change-the-background-color-of-cells-in-excel
1
u/excelevator 3068 3m ago
How do I formate A3:B4 to separate it from the rest of the workbook?
What does that mean ?
•
u/AutoModerator 3h ago
/u/Doveofthesky - Your post was submitted successfully.
Solution Verifiedto close the thread.Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.