Paint cell according to dates in excel

Asked

Viewed 395 times

0

I have a worksheet to control activities, it contains a table with "expected start" and another with "expected end", within this table have dates as an example:

24/07/19 formatted to leave in this condition.

My question is, I would like to insert a date, be colored the day of the week of the same, counted from the current day. I tried with several formulas as example WEEKDAY; TODAY. And both did not present the expected result.

inserir a descrição da imagem aqui

excel

  • I believe that there is or it is very complex to accomplish this only with Excel formulas. And when working with weeks, there are some problems that can occur because the year has 365[,25] days. So it is recommended to ISO week date, Anyway, you can create a program in VBA to accomplish this, because I have not seen a way to accomplish this easily with conditional formatting. But you can take the number of the week with NÚMSEMANA or WEEKNUM. And make a conditional formatting for each set of columns of weeks. Laborious...

1 answer

1

Tente algo parecido com isso

replace the first value "1" in the other formulas with the value of the week corresponding to the day, for example, Monday =1 , Tuesday =2

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.