Questions tagged [conditional-formatting]

For questions about conditional formatting in spreadsheets.

Filter by
Sorted by
Tagged with
3
votes
3answers
238 views

Conditional formatting for columns, date & time specific?

I have uploaded 4.000+ Venmo donation data sets into Google Sheets for sorting, but the date and time is preset and looks like this: 2018-11-01T20:16:52 I have tried multiple approaches to sorting ...
0
votes
1answer
6 views

Google Sheets conditional formatting multiple columns with ignoring blank cells

I want to highlight the cells in E/F/G columns when they exactly match the score in column D, but I want formatting to ignore blank D cells. Can I do this somehow?
0
votes
1answer
16 views

Minimum value across multiple rows, conditionally formatted

I need help understanding how the MIN formula mixes with conditional formatting, cause I can't wrap my head around it. Here's specific situation: I've successfully got formatting for minimum across ...
0
votes
1answer
476 views

Google Sheets Conditional Formula

Google Sheets formula for outputting PASS or FAIL in one cell based on the color (green or red) of another cell?
5
votes
3answers
10k views

Is there a way to lock or protect conditional formatting in Google Sheets?

I have several columns that indicate the current state of a project task. When I complete some task (for example), I copy the "complete" text from some other cell and paste it in the new cell to avoid ...
2
votes
1answer
27 views

How to elevate a conditional format rule to be the number one rule instantly

I would like to make a newly created rule for conditional formatting the top rule so it has precedent over all others but be able to do so without having to drag it to the top as this takes for ever ...
0
votes
1answer
13 views

Conditionally Format Non-Blank Cell in Range When Adjacent Cell on Same Row Contains Either or Both of Two Specific Values

Building on a question I asked here, I am trying to conditionally format the non-blank cell within a range when an adjacent cell on the same row contains either or both of two specific values ("...
0
votes
1answer
35 views

Conditional formatting formulas in Google Sheets

I want to use Conditional formatting so all of the cells in column A change colors whenever the matching cells in column B have the word "later". ex: If cell B20 contains "later", then I want A20 to ...
0
votes
1answer
15 views

Google Sheets - conditionally format a cell based on whether the content of the cell appears in a column from a different sheet?

I have a sheet called Master that contains a column of names in cells A1-A60 (e.g. A1: Ann,A2: Bob,A3: Chris, A4: Donna, etc.). I have another sheet called Subsheet that contains names that may or ...
3
votes
2answers
465 views

Conditional Formatting in Google Sheets

The shorter question to spare you from reading more than you need to I have a few different formulas for use in conditional formatting with custom formula in Google sheets. They are all roughly 1100 ...
0
votes
1answer
2k views

Can I use conditional formatting to highlight a cell for dates less than 30 days away?

I have a large spreadsheet where I need to keep track of coming expiration dates and I would like dates which are within 30 days from today's date OR which have already passed to be highlighted in red....
0
votes
1answer
18 views

How can I highlight a column of cells (H) if the date in the cell is more than a week old, and the cell next to it (I) is blank?

I'm trying to make a spread sheet to track open purchase orders. One PO per row. One column has the order date in it, and the next column has the receive date for the order. I'd like the cell with the ...
0
votes
1answer
2k views

Google Sheets - Highlighting Cells if they contain text from another range of cells

I want to highlight a cell in a column with a specific color if it contains any of the elements from a range of cells on another sheet. I believe I need to use 'custom formula is' with the INDIRECT ...
0
votes
1answer
34 views

I want a custom conditional formatting to fill a color for a cell depending on the number value after the decimal point

I am entering both positive and negative numbers in a column and want a way to identify them without an extra column for example -100.03 or -250.1 or 100.015. in this example I am listing moneyline ...
1
vote
1answer
885 views

google sheets checkbox conditional formatting

I have a schedule where I use inspector name, job number and then checkboxes to book the inspector on the visit date What I'm looking to do is if an inspector is booked in a job on lets say jan 3rd ...
0
votes
1answer
16 views

Conditional formatting with custom formula: a block of cells

I am trying to highlight all the values in B2:D4 that are greater than the value in B7. Tried with =or(B2>B7,C2>B7, D2>B7) and others, but I could not get what I wanted.
0
votes
1answer
41 views

Google Sheets Conditional Formatting Cycle

In Google Sheets I would like to color a cell depending on if the cycle is on or off. The cycle is for 10 day the cycle is ON then for 5 days the cycle is OFF then repeat. So if I start the cycle on ...
0
votes
1answer
24 views

Create a RAG system based on dates, upcoming and expired within Google Sheets

I want to create a RAG system in google sheets based on dates in a cell. Column A will show a date when someone is trained on a topic and column B shows the due refresher date (3 years later). I want ...
0
votes
1answer
26 views

Conditionally Format Non-Blank Cell in Range When Adjacent Cell on Same Row Contains Particular Value

I am trying to conditionally format the non-blank cell within a range when an adjacent cell on the same row contains a particular alpha value (ach in this instance, regardless whether ACH is written ...
5
votes
5answers
8k views

How can I select all cells that contain specific text in Google Sheets?

I have a spreadsheet that contains 20,000 cells. I want to select all cells that contain "foobar". In other words, I want to highlight them so that they can be copied, formatted, etc. How ...
0
votes
1answer
58 views

If cell y contains any word from range x:x, mark cell y green

In Google Sheets, I have three columns (with different lengths!) Column1 contains firm names (50) Column2 containts firm names (100) I would like to mark a cell in Column1 green (or with a number in ...
1
vote
1answer
1k views

Google Sheets Conditional Formatting only applying formatting to certain cells

I am currently working on making a spreadsheet that will figure out which class I should be in based on times. That all works and outputs if I should be in the class to a TRUE/FALSE cell. My ...
1
vote
1answer
73 views

Conditionally format a column if it contains all the values in a set

Each of the columns in my Google Sheet represent a farm. Each farm is a list of animals. I want to highlight the entire column if the farm has a duck, a horse, and a cow. So the column may look like ...
2
votes
1answer
2k views

How can I get a cell to change its value based on another cell's color?

I have three colors in column F: green, grey and red. What I want is for column G to display a number (1, 2, 3) depending on the color value of F. Is there a way to do this?
0
votes
2answers
31 views

How can I apply a conditional format in Google Spreadsheets based on multiple factors?

So I'm making this attendance tracker for my school, and I need to apply a different format depending on the value of the cell and if a checkbox is ticked or not. Here is a screenshot of the different ...
0
votes
1answer
184 views

Conditional Formatting in Google Sheets based on the same rows conditional format

I have a spreadsheet where I have tasks, and I prioritize those tasks based on high, medium, and low levels. I currently use conditional formatting for this, so if I select from a drop-down "HIGH", ...
1
vote
1answer
311 views

Conditional Formatting based on another sheet, tying a value to a colour, Google Sheets

Does anyone know how I'd be able to make a specific value always appear with the same formatting & colour in my sheet, based on another tab in the sheet? The spreadsheet I'm trying to do this on ...
1
vote
1answer
590 views

Conditional format custom formula in Google Sheets

Have a question on how to do a custom formula in conditional format for the following: A1 = DCC220 B1 = 7.50 C1 = 7.00 D1 = 7.60 I want to compare the result in B1 (7.50) to a range, C1 lower, D1 ...
0
votes
1answer
3k views

Google Sheets Conditional Formatting for expiration dates

I need help! I need to create conditional formatting for expiration dates: Cells should stay green Cells should turn yellow when 1 month of exp. date Cells should turn red once expired
1
vote
2answers
21 views

How do I detect duplicates in two worksheets?

I have 1 Google Sheet with 2 worksheets: Worksheet "1" has 1 column A with 5 lines of data (AAA, AAB, AAC, AAD, AAE) Worksheet "2" has 1 column A with 5 lines of data (AAA, BBB, CCC, DDD, EEE) I ...
0
votes
1answer
32 views

How to add multiple conditions onto a query

so this is completely experimental and not for a class. If anything, I'm doing this because I don't really have class right now. I am self-taught and very inexperienced when it comes to anything code ...
0
votes
1answer
75 views

Google Sheets: Need conditional format formula to parse number-hyphen-number input into “2-Tuesday” type

I want to write a conditional formatting formula that will convert 1-3 to 1-Thursday, 2-2 to 2-Wednesday, 3-1 to 3-Tuesday, 4-0 to 4-Monday. The rationalization being I have a list of committee ...
0
votes
0answers
14 views

Add more conditional formatting cell highlight color options in excel online

In excel online (such as a spreadsheet tab in teams), you can add conditional formatting to highlight a cell that contains a certain value. But there are very limited options for highlighting colors ...
1
vote
1answer
1k views

How do I conditionally format text color to match across sheets in Google Sheets?

Edit: I couldn't figure out how to post pics without editing, so I added them to the OP. The first photo is the process form. On the form, as the boxes are checked the color changes from black to red ...
1
vote
1answer
22 views

Using a custom formula on a sheet that is constantly expanding

A custom formula for 5 possible colors, by day is used to highlight entries by DayOfWeek Is it possible to use a format like A2:A instead of manually editing it as the sheet grows bigger? Formula ...
0
votes
1answer
22 views

Conditional formatting skipping colors after the same large value

Looks like the conditional formatting skipping large formula because of the same large values. Help me please how can I get the order what is on the picture in the column "What I would like".
0
votes
1answer
27 views

Conditional formatting for passed dates

I need the formula to highlight a cell if the date in that cell has passed. Cell U3 had 6/29/19 today is 7/1/19 - I want to have the cell turn red after 6/29 to alert me to follow up.
0
votes
1answer
31 views

highlight if value is duplicate and corresponding cell of all other duplicates is blank

I have a list of clients who contacted us. We need to get back to them. I would like to format if: They appear twice in the list (got that) and We have not gotten back to them in any of their ...
1
vote
1answer
49 views

AND / OR Conditional Formatting for Google Sheets with multiple criteria

I am trying to write a custom formula to conditional format column E by referring to the different tenure level targets in column D to indicate if they are hitting their targets base off of their ...
3
votes
2answers
196 views

How to Apply Conditional Formatting Based on Adjacent Cell Value for Entire Column?

I am looking to apply conditional formatting to all cells in a column (excluding the header) where a colour will be applied depending on if its value is greater, equal, or less than the adjacent cell. ...
1
vote
1answer
981 views

Conditional Formatting across a range of cells with a formula in Google Sheets

I have a calendar put into Google Sheets with the data put in as dates such as "9/24/2018". I have a separate sheet with a data set that has rows that classes end such as "9/24/2018". I want to ...
2
votes
1answer
69 views

Google Sheets date conditional formatting

I have dates in column D in Google Sheets. I want the cells to highlight red if 30 days have passed and there is not a comment date in column F. Example: Column D: Submittal Date 6/29/2019 ...
0
votes
1answer
208 views

Utilize SI units in Google Sheets

Seven years ago this was asked, are there any new developments with regard to formatting with SI units? Normally, I will adjust the format to be all milli or micro simply by division, however my ...
0
votes
1answer
56 views

Conditional formatting with multiple names in list

Col A2:C15 contain a list of names. I need to enter those names in various combinations into one of 15 other cells on formatted like: H3 = John, Steve, Bob, Dan Is there a way to use conditional ...
0
votes
0answers
24 views

Google Sheets formatting

I have a workbook in Google Sheets and it is for a schedule for my company so I have a few sheets in my workbook that have the days of certain weeks and then one more tab that has inventory ...
0
votes
0answers
6 views

Google Sheets and conditional formatting [duplicate]

I have a workbook in Google Sheets and it is for a schedule for my company so I have a few sheets in my workbook that have the days of certain weeks and then one more tab that has inventory ...
0
votes
1answer
29 views

Google sheet - highlihghting cell if in the same row other cell not empty

I'm trying to make a worksheet where I log shift hours. I made columns with dates and to each date a row of hours I want the date text to be green if in the same row a cell is not empty.. The code I ...
0
votes
1answer
57 views

Change cell colour based on another cell containing text

I am new to Google Sheets and trying to create a custom formula in conditional formatting. Looking to see if someone would be kind enough to help. The picture below is a sample size of two list of ...
1
vote
2answers
2k views

Conditional Formatting based on other column

I have a timesheet log with columns DATE | HOURS | DESCRIPTION OF WORK | PROJECT An employee may enter several rows for the same date to log the different amount of time with respect to the ...
0
votes
1answer
28 views

Call if conditions from another cell in google spreadsheets

I want to define conditions in cell values and pass them in if statements in google spreadsheets. This is a simple formula how this can be achieved normally This is what I am trying to achieve. ...

1
2 3 4 5
8