EXCEL Highlight All Dates from a Specific Year

Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.

Lista Forumurilor Pe Tematici

Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login

POZE MRRRR'S FORUM (VIEW ONLY)

Nu sunteti logat.

Nou pe simpatie:
Profil sarmaluta2002

Femeie
25 ani
Bucuresti
cauta Barbat
25 - 50 ani

Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] Highlight All Dates from a Specific Year

Moderat de TRaP, TonyTzu

Autor

Mesaj

Pagini: 1

TRaP
Moderator

Inregistrat: acum 6 ani
Postari: 787

While with Conditional Formatting - Highlight Cells Rules - A Date Occurring... you can highlight dates from previous/this/next week/month, you can't highlight dates from the current year for example.

Create New rule, formula: =TEXT($L9;"yyyy")="2019"

Source:

pus acum 5 ani

Pagini: 1

Mergi la