Google Sheets conditional formatting with differently styled dates
in Google Sheets I'd like to format an area of cells automatically by comparing its date value to another cell. In fact, I have some cells representing a month (the area of cells to be formatted) and a single cell with another date (05.05.2022 formatted as 05.05. see screenshot).
So date for homework is located in U6 and cell area for moth of may is K11:Q16. When I set conditional formatting to
apply to range: K11:Q16
and
Date is: exact date: =U6 or custom formula is: =U6
it does not work. But when I set range to N12 (05.05.2022 formatted as 5) it does work.
Any ideas?
Thanks in advance.
edit: I created a separate sheet for sharing, so this does not fit to the screenshot: https://docs.google.com/spreadsheets/d/1gBx3dbzxk3Qb999uo3YMdz0A9-ViSE4xPeihhasN7FQ/edit?usp=sharing
try like this:
=COUNTIF($I$2:$I$5; D11)
or:
=MATCH(D11; $I$2:$I$5; )
- How to extract date from datetime column in polars
- Get dates from a week number in T-SQL
- Kotlin extract time form the date
- Trying to list all the mondays and their dates in a year
- data frame breakdown by year, rounding up by duration of each period
- Display averages of a column for past five months in Google Sheets
- Parsing csv file output before certain date
- Date.now() equivalent in Go
- Is the Javascript date object always one day off?
- How To Convert String ' dd/mm/yy hh:MM:ss ' to Date in javascript?
- DateTime Django. Capitalize the first Letter in French
- dataframe breakdown by year
- How do I identify consecutive/contiguous dates in polars
- SQL syntax for Same Date Last Year
- Formatting a Date String in React Native
- How to create a new date by using one's date part and other's time part?
- SQLAlchemy default DateTime
- MySQL: Date String to Date to Month coming back as Null
- How do I get 'date-1' formatted as mm-dd-yyyy using PowerShell?
- From milliseconds to hour, minutes, seconds and milliseconds
- Format date from YYYYMMDD to YYMMDD in Javascript
- PowerBI line chart by month
- How do I speed up this strftime('%Y-%m', time_UTC) query?
- C# Data type for Birthdate
- Is there a date format to display the day of the week in java?
- getDay() method to return day of the week for a given date not works
- In Python, how do you convert seconds since epoch to a `datetime` object?
- Detecting an "invalid date" Date instance in JavaScript
- Getting a specific value as an output from a function
- Displaying the build date