Forum Discussion
Check the value of a function
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 You may use Conditional Formatting to achieve what you describe. It formats cells based on its displayed content, not the underlying formula. A working example is attached.
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.
spamitovic Add the dollar signs as mtarler suggested and it will work.
Thank you so much for your help. Problem solved now.
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)