[Solved] Cell Background Adjusting

Discuss the spreadsheet application
Post Reply
Blue_chip
Posts: 3
Joined: Tue Jul 18, 2017 12:13 pm

[Solved] Cell Background Adjusting

Post by Blue_chip »

Hi! I just wanna ask about the cell background please refer to the attachment for the illustration.

Is it possible whenever I change the date, the columns that will fall under weekends will Automatically Change the Color ?? Im Using open office 3.4 and I wanted to set it in Macro.

Hope you can help me with this case

Thank you in advance!
Attachments
Cell Color.jpg
Last edited by Hagar Delest on Wed Jul 19, 2017 10:01 pm, edited 1 time in total.
Reason: tagged [Solved].
openoffice 3.4
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Cell Background Adjusting

Post by acknak »

Greetings and welcome to the community forum!

Do you have to use a macro for this? Format > Conditional formatting should be adequate.
Attachments
conditional_weekend.ods
(11.19 KiB) Downloaded 61 times
AOO4/LO5 • Linux • Fedora 23
Blue_chip
Posts: 3
Joined: Tue Jul 18, 2017 12:13 pm

Re: Cell Background Adjusting

Post by Blue_chip »

Thank you so much!!!! Acknak!
It helps me a lot! :bravo: :bravo: :bravo:
I'm just a beginner in Open Office!
Hopefully you can help me with my other question soon!

Regards!
openoffice 3.4
Post Reply