Are you stuck on Excel or Google Sheets?

Hello, I need help with conditional formatting. My issue: I have a delivery schedule that I need to track. If the order is created between 00:41 and 01:40, delivery time must be by 02:55. If the order time is between 01:41 and 02:40, delivery time must be by 03:55, and so on throughout the day 24hr. I need help creating a format that will highlight anything delivered past its scheduled time . Thanks.

I need a formula to find similarities in one column of excel data (12,000 rows) that would clearly indicate the cells that are extremely similar to another cell, even if not a direct match. I tried fuzzylookup and that would not work as well as the conditional formatting rules.

I have data importing from a program, and I want to use the Conditional Formatting Tool to set up a rule to highlight any given values that do not fit the requirements. I was wondering if there's a way to set up an excel page that has these rules set up, so when the data is imported, it automatically will be highlighted if the rule is commanded. I only have been able to import data onto another sheet, and had to set the rules up after the data is imported.

Hi there im just wondering if it would be possible to create a conditional formatting that allows you to click on a point in a scatter plot and have it highlight a row/cell of data?

neeeeed helppp in a sheet I want to use conditional formatting with multiple criteria it is a difficult taks please answer if you can do that asap please

I need a conditional formatting with a formula between 2 dates. If A1 contains the date July 8, 2018 & A2 contains the value of A1-7 (date) - how do I apply this to a conditional format to have A2 turn red if true

Is there an actual function that changes cell colour rather than Conditional Formatting? It wouldn't work in this situation. I basically have an IF statement and I want the TRUE result to be the colour of the cell changing. Ive tried setting it to "1", then setting a rule where all "1" become that colour, but nothing happens. I've tried it with and without the quotations.

just trying to use Conditional Formatting to compare items listed in column F to items listed in column G (1 for 1) to highlight/find the ones that that are duplicate. For example, I just want to know if F2 and G2 are a match, NOT if F2 has ANY matches in the entire column of G...

I'm working on an Excel spreadsheet with 7 columns. If there is a DATE in column 5, I'm wanting the whole line formatted with strikethrough. How do I do this under conditional formatting? Or, is there another way?

Column A contains name of participants. Column B contains the binary info of whether the participant won. If won, then 1, if lost, 0. So, if I assign 1 to column B(meaning the participant won), I want the cell in column A&B to be highlighted in green. Used Conditional formatting. But unable to assign this rule to all participants at once. Instead, I have to conditional format every participant.