Questions tagged [conditional-formatting]

For questions about conditional formatting in spreadsheets.

Filter by
Sorted by
Tagged with
0
votes
0answers
19 views

How to apply CF to rows where there is a duplicate/multiple word in a specific column, AND use a unique color for each different duplicate

I want to have Conditional Formatting apply a color to rows when a word shows up in one particular column, but only when there is more than once instance of that word in the column. So for example if ...
0
votes
1answer
32 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
49 views

Conditional format based on data in 2 columns

I am trying to create a conditional format that will highlight cells across 2 separate columns based on data in both columns: So I need to highlight all cells in column A that is greater than 0 AND ...
0
votes
0answers
76 views

Code Run by Google Script Editor has Unwanted Effects on Google Sheet Conditional Formatting

I manage a "tasks" spreadsheet our office uses to coordinate. There are two main features that make it useful: A script run with OnEdit trigger sorts the rows alphabetically by column E, which lists ...
0
votes
0answers
17 views

Conditional formatting if one cell is one hour later than the actual time

I have column A with fixed time cells (let's call it time_should), and I have next to them in column B, cells with (time_is). What I would like to do is a conditional formatting of the cell that if ...
0
votes
1answer
30 views

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

If a recipe is checked, I want the formula for the conditional formatting to be looking for a recipe match (of all of the recipes checked (for which rows column C is True)) in D3:G7 and highlight ...
0
votes
1answer
35 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
2answers
27 views

column conditional formatting based on its sum

I have column F2:F23. I want the background of that entire column (F2:F23) to either turn red or stay neutral based on whether the sum of the column is greater than the number at cell C2. I tried ...
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. ...
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 ...
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
33 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 ...
0
votes
1answer
59 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 ...
0
votes
1answer
197 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", ...
0
votes
1answer
59 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 ...
0
votes
1answer
590 views

How to detect duplicates across multiple sheets?

I have found a couple of formulas/scripts for what I am looking for, but they are all locked for one sheet only, thus I will try to explain what exactly I need. I am unable to do it my self, because ...
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
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
58 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
1answer
91 views

Conditional formatting on whether something is a formula in Google Sheets? [duplicate]

Is there a way, in Google Sheets, to have conditional formatting of some sort, to change the background color of a cell based on whether the cell contains a formula or a plain value?
0
votes
2answers
24 views

Using IF functions with formatting in Google Sheets

I'm working on a Google Sheet and want to reformat all instances where the number in a cell is "2" and the color of the cell is pink. Is it possible to use information about cell formatting (here, e.g....
0
votes
1answer
36 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
17 views

Changing cells formatting based on another cells date

I've been looking and can't quite find the answer I'm looking for. I have a spreadsheet with columns Monday through Saturday with data lining up underneath. I would like the current day to highlight ...
0
votes
2answers
76 views

Format cell if all the cells in a row are not empty

I tried all kind of formula but they all seem to work the other way around for me. I have a very large sheet with lots of columns. I'd like to have the first cell in the row to be a certain color if ...
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
0
votes
1answer
39 views

Flagging empty cells if date in another cell has passed

Good afternoon! I've created a test sheet to help visualize this - https://docs.google.com/spreadsheets/d/1-qHH4GfeIZz-7OBHFpp4trrFNg7l-gBHDT2MHg9tFmE/edit?usp=sharing I'm aiming to have cells ...
0
votes
2answers
522 views

How to apply conditional formatting only if cell has X value? [google sheet] [duplicate]

I have a sheet with statistical data to which I had applied color scale conditional formatting. Some rows I set to have green for highest and red for lowest number in row and other rows the other way ...
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
548 views

Google Sheets Conditional Formatting Multiple Cells with Different Colors

I am studying for a big exam and want to set priorities using conditional formatting. For example if C90, C91, C92 are blank than the color would be white; if C90, C91 are blank but C92 is not blank ...
0
votes
1answer
51 views

Dependant Multi Conditional Formatting

So I am building a spreadsheet and everything was working fine but then I kept tinkering with it and making it more intuitive (and less work on the user) and ran into a snag. What I am trying to do ...
0
votes
1answer
489 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?
0
votes
1answer
330 views

Conditional formatting based on dependent variable cells

Apologies if the title is unclear -- if anyone can suggest better wording I will change it. I wasn't sure how to condense this question into a single sentence. I have a spreadsheet with three columns ...
0
votes
1answer
1k views

In Google Sheets how can I conditionally color a cell value if less than another cells value?

The Sheet I am working with has a multiple columns, each with a range of integer values. I would like to check to see if that integer value is less than another cells integer value, and if so ...
0
votes
2answers
1k views

Conditionally format cells that not match with range from Sheet2

I have two sheets in the same file where "sheet1" has cleaned up information and "sheet2" has the dump from my Jira. Now I am trying to compare Column F from sheet1 and sheet2 to ...
0
votes
4answers
54 views

Show a Running Target Based on Today

I'm creating a running target from a quarterly Total divided by known trading days Current formula in I4 is =IF(H3<>"",I3+O$30,"") H3 = Yesterday's Sales Numbers I3 = Yesterdays Running Target ...
0
votes
3answers
5k views

Use conditional formatting to add text

Is it possible to use conditional formatting to edit/add text in a cell? E.g., if it matches the custom formula "=B9>A9", add "is greater than A9" as text at end of whatever is in B9. I didn't find ...
-1
votes
2answers
6k views

Change a cell to a colour when a tick box is checked in another cell

I have a cell with a checkbox. I want another cell which contains a date to go green when the tick box is checked. I presume this is done in conditional formatting but I am struggling with it.
-1
votes
1answer
390 views

Conditional formatting

I'd like the date / time that is in the past to turn red. The table has dates and time in different formats. Can I use one rule to do everything? If not is it possible to do so? I've tried =today()...
-1
votes
1answer
16 views

How to apply conditional formatting to part of a string in one cell in google sheets [duplicate]

I'm not sure this is possible but thought it was worth the ask: I'm trying to use conditional formatting to change the colour of part of a string contained within a single cell in google sheets. I ...
-1
votes
1answer
506 views

How to highlight current row and next row if checkbox is true with conditional formatting (Google Sheets)

Is there a way to apply conditional formatting to an entire Google Sheet so that for every checkbox marked true, it highlights the entire row and the next row? My sheet has a checkbox in every other ...
-1
votes
1answer
16 views

I'm looking for help with a formula to automatically update 10 previous days on a frequency count

I'm working in behavioral analysis and trying to implement a formula the would track and automatically update the number of behaviors per time period. We track the 10 previous days, which gives us ...
-1
votes
1answer
31 views

I would like to use conditional formatting with references to another sheet

In a sheet of a Sheet doc, I would like to use conditional formatting : Which applies to my sheet1, range E8: UH49 Custom formula: = OR (COUNTIF (Holiday1; E5); COUNTIF(Holiday2; E5)) With Holiday1 ...
-1
votes
2answers
82 views

Mark all line if checkbox is true

I will give an example: I have checkboxes in B3:G3. This is a checklist, I want to change the background color to green for A3:H3 if B3:G3 boxes are checked. Can someone please tell me how to do ...
-1
votes
2answers
3k views

Conditional formatting by using the note in Google Sheets

How can I use conditional formatting by using the note on a specific or many cells in Google Sheets? For example, I would like to set up conditional formatting to a specific cell and when I use a note ...
-1
votes
1answer
122 views

Apply the conditional formatting formulas across every column of the sheet

I've got a Google Sheet that I'm trying to write some formulas for - it's basically just a bunch of numbers in columns that I'm trying to do some conditional formatting on (per column). I want to be ...
-1
votes
1answer
386 views

Transposing with header row

In Google Sheets I'm trying to transpose a list of items in rows to display as columns. I am looking for a way to transpose the Category field to act as a header row that extends over all the items of ...
-1
votes
1answer
3k views

Conditional formatting with multiple criteria over a range of cells

There is another thread about this but all of the answers there aren't helping. In the range: D12:AY500 - I have a matrix of numbers such that: y=Date, x=Time: .. I would like it so the cells ...
-1
votes
1answer
413 views

Google Spreadsheets formula should I use for highlight more than an 1hour passed between cells?

I need help with a Google spreadsheet formula. This is what I'm trying to do: Highlight the cells in “Conditional Formatting” where the time spent between 2 cells is more than 60min. In this case ...
-1
votes
1answer
78 views

Adding 24, 48, 72 hr highlights to cell for tracking purposes [duplicate]

I am trying to add conditional formatting that turns yellow after 48 hours from the date in the cell, turns orange after 72 hours from the date in the cell, and red after 96 hours after the date in ...
-3
votes
1answer
5k views

Google sheets with conditional formatting not working

Update: I want one specific cell to become green (filled with green color) if a range of other cells (which contain only dates) count up to 7 or more filled cells AND contain dates within a specific ...

1
5 6 7
8
9