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:
Lorena13
 | Femeie
19 ani
Bucuresti
cauta Barbat
26 - 40 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
Compare dates in 2 columns and conditional formatting
Select column B then use Home -> Conditional Formatting -> New Rule. Once the New Formatting Rule dialog is open, choose Use a formula to determine which cells to format and supply the following for the Format values where this formula is true: text box.
=AND($BL8<=($BK8), ROW()>1)
GREEN
=AND($BL8>($BK8), ROW()>1)
RED
If you want to compare with 2 days before:
=AND($CM8<=($BO8-2), ROW()>1)
GREEN
=AND($CM8>($BO8-2), ROW()>1)
RED
|
|
| pus acum 7 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Compare dates in 1 columns to date in 1 cell and conditional formatting
I want to do conditional formatting on range E3:E35 containing dates and color every cell with a date older than the date in cell E1.
Conditional formatting formula:
=$E3-$E$1<0
or
=$E3<$E$1
|
|
| pus acum 4 ani |
|