Forum Discussion
spamitovic
Sep 06, 2020Copper Contributor
Check the value of a function
Hi all, I have a table that contains all current month days, the days are displayed on each column. For example, in my B1 cell, I added the following function: =DATE(Tableau2[Current year],Tab...
- Sep 08, 2020
spamitovic The translation isn't very good but I think what you want is to add '$' in formula as so:
=OR(WEEKDAY(C$3,2)=6,WEEKDAY(C$3,2)=7)
spamitovic
Sep 07, 2020Copper Contributor
Riny_van_Eekelen Yes but I can apply these conditions only the two first line.
You can check in the attachment, when I try to select all tables, the condition is applied to other cells that are not required.
I need to change the background only for the weekends.
Riny_van_Eekelen
Sep 08, 2020Platinum Contributor
spamitovic Add the dollar signs as mtarler suggested and it will work.
- spamitovicSep 08, 2020Copper Contributor
Thank you so much for your help. Problem solved now.