conditional formatting on a single cell where criteria is another column [solved]
Cell A1 contains the text "FLAG".
Column B contains dates.
I want to apply conditional formatting to cell A1 if any date in column B is less than 2 days from today(), and if the date is past today().
An example of what I've tried:
Column B:
10/12/2024
11/12/2024
06/12/2024
Assuming today is 04/12/2024, conditional formatting applied to Cell A1:
=$B$1:$B>TODAY()+2
I would expect cell A1 to flag as it meets the criteria with date 06/12/2024.
=$B$1:$B>TODAY()+1
I wouldn't expect cell A1 to flag.
If I add the date 01/12/2024 to column B and remove 06/12/2024,
I would expect the cell A1 to flag with either of what I've tried.
Neither option has the desired result.
Thanks.
Solution
Custom formula is:
=+sort(xmatch({today()+1;today()+2},B:B))
- How to create a formula that will repeat a range by splitting one column and joining with the other column?
- Google Sheets Splitting Text to Rows and Duplicate Surrounding Rows Entries
- How to transpose & split multiple columns and repeat specific cells in a column
- How do you deal with multiple values in a single cell separated by comma?
- Copy specific fields to another sheet
- Find Text and copy another cells
- Generating date range based on allowed weekdays, repeat times and times of day in Google Sheets
- How to use a query within a query?
- Find first empty row and scroll to it, Lastrow not working due to formulas
- Map a table, replacing values based on other cell
- Sum value if matching value is not blank in range leaving it blank if empty
- A Script to Simplify Creating a SO Table
- Google Sheets API v4 and valueInputOption
- Get Google Sheet by ID?
- ReferenceError: C is not defined
- How to sum up multiple VLOOKUP results?
- Conditional Formatting in Google Sheets with another table INDIRECT
- How to reference a cell to the left of active cell in Google script
- How to show instruction with image after install google workspace extension?
- How to use SpreadsheetApp.Spreadsheet.getChanges method?
- Get the user that changed specific cell
- Daytime and Nightime Occurrence Duration of an Event
- Recombining 4 pairs of numbers
- GmailApp.sendEmail: is it possible to schedule send an email?
- Why do I get the error SPLIT parameter 1 empty error when it isn't?
- Is there a faster way to sort sheets with AppScripts?
- ISO-8601 String to Date in Google Sheets cell
- How can we sort multiple values ​horizontally using VLOOKUP?
- COUNTIFS WITHIN DATE RANGE GOOGLE SHEET
- conditional formatting on a single cell where criteria is another column [solved]