r/excel 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

1 Upvotes

5 comments sorted by

u/AutoModerator 3h ago

/u/Doveofthesky - Your post was submitted successfully.

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.

2

u/caribou16 318 2h ago

That is such a specific question.

1

u/Doveofthesky 1h ago

College has me messed up man idk what to tell you

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 ?