• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how do i format the cell appearance based on their date value?

jack abbey

New Member
how do i format the cell appearance based on their date value?
for example i have a column with many dates in the rows
&, i want to make the cell contents Bold if the date of the cell is less then the next sunday
so if the date is older then today, or its within this week, then i want it to become Bold automatically
so like this i can see all appointments due.
can anyone help me with that?
 

p45cal

Well-Known Member
A file would be helpful, in the meantime there is built in conditional formatting for dates:
73227
then:
73228
 

jack abbey

New Member
thanks
work perfect
however, i want to highlight every occurrence from beginning of time until the end of this week, not just this week, but everything UNTIL and including this week, i cant see any option for that, thanks
 

jack abbey

New Member
the only way i slightly managed it is by using a formula:
(where A2 is the date)
=$A2 < TODAY()+9-WEEKDAY(TODAY())
although for some odd reason it leaves out some rows, but its 99% ok
 
Top