I would like to highlight the object cell when there is an value in the the same row and week is highlighted.
using =C$2=WEEKNUMMER(VANDAAG()) to highlight week.
Example:
objects 3, 7 and 10 should be also higlighted because they have a value in the active week
something like: when contains value and in active week (column) then highlight cell in column "B" row x
Bookmarks