Skip to main content

New answers tagged

0 votes

Conditional formatting if cell text matches one of multiple other checked cells texts

Conditional Formatting formula For each value in D3:G, count how many rows in $B$3:$B have the same value, and also $C$3:$C is checked (true). Formula will be interpreted as True for any non-zero ...
Blindspots's user avatar
  • 6,044
0 votes

Conditional formatting formula to highlight duplicates but only if the date equals today

TL:DR =AND(INT(A3)=TODAY(), SUMPRODUCT(INT($A$3:$A)=TODAY(), $B$3:$B=B3)>1) Exclude Time You need to remove the times, (fractions of days) from the dates when comparing to TODAY. The INT function ...
Blindspots's user avatar
  • 6,044

Top 50 recent answers are included