Questions tagged [conditional-formatting]

For questions about conditional formatting in spreadsheets.

Filter by
Sorted by
Tagged with
0 votes
1 answer
26 views

Check if any cells in one column fall between cells in different columns in Google Sheets

So I'm trying to figure out if any call for service happens during the time frame of another call. The information is set up below like this: | |[A]|[B]|[C]| |:---|:---|:---|:---| |1|"Call Time&...
user avatar
0 votes
1 answer
27 views

How to us Conditional Formatting with color scale based on data in another cell

need some help with conditional formatting. Take a look at the sheet below. I would like to apply conditional formatting to D20 based on the vales of C20. For example, I want it to be on a color scale ...
user avatar
0 votes
2 answers
24 views

Can I use a drop down list to color-code a cell with Conditional Formatting, without displaying the text of the dropdown list option?

I know how to create a drop down list of options, and how to use conditional formatting to change the color of a cell based on the selection from the list. However, I do not want the list item ...
user avatar
  • 3
0 votes
1 answer
24 views

How to conditional format in Google Sheets based on a external resource

I have a Google sheet that has a value of a stock I bought in the past. The page was stark with just white cells and black text. So I decided to brighten it up with some colour. One thing I want to ...
user avatar
0 votes
0 answers
15 views

YES/NO dependent drop down list

I would like to have a "YES" or "NO" dropdown list in cells A6, K6, L16 & K16. I want only one of those 4 cells to be YES and that automatically changes all other cells to NO. ...
user avatar
  • 1
0 votes
1 answer
25 views

Conditional formatting - color cell if less than cell to the left - (inverted yield curve)

Example In the following, K2 is less than J2, so it's highlighted in red: Conditional rule This was easy to achieve with the following conditional rule: Question What's a good way to get that rule ...
user avatar
0 votes
1 answer
23 views

How to highlight duplicate values when clicking on a specific cell

I'm new to spreadsheets, but trying to put a functional one together for my team. I have a list of member names, and several lists of tasks they are assigned on different days of the week. The goal is ...
user avatar
0 votes
1 answer
99 views

Concatenate multiple cells in one cell based on ID

I'm trying to figure out a formula for concatenating data in cells based on a condition. Specifically, I need to output rows for each unique "Conversation ID" (found in column C) and ...
user avatar
0 votes
1 answer
20 views

Google Sheets: Possible to set conditional formatting based on contents of a different cell also using a formula?

I have a schedule-type sheet with an updating weekday value (one cell with =TODAY(), one cell referencing the date cell with =TEXT(A1, "ddd"), converting the weekday value into a 3-letter ...
user avatar
  • 3
0 votes
1 answer
15 views

How do I higlight a cell certain colours depending if it's higher or lower than another cells value?

I want to have a cell highlighted Green if it's above the average score, amber if it's within 1000 points less than the average score, and red for any value below that. Even excluding the 1000 point ...
user avatar
0 votes
1 answer
22 views

I want conditional formatting to turn the cell green if it is < or = 1.99% of the lowest value in the range

I’m using Google Sheets. First, I want conditional formatting to find the lowest value in a range. I've done this by entering "=G3=min($G3:$N3)" for the custom formula. After that, I want ...
user avatar
0 votes
1 answer
12 views

Can I highlight a cell after a set period of time?

Hi I am trying to have a cell highlighted after 15mins starting on a time based on another cell. For example, Cell1 has 1:00:00 PM as its value, if Cell2 is blank after 15mins it would be highlighted ...
user avatar
  • 1
0 votes
1 answer
25 views

Conditional Formatting in Google Sheets doesn't work in certain cells with custom formula

Custom Formula doesn't work on certain cells. A little background, I am making a timezone sheet for a discord where someone input the time they wanted and checks who is and is not available at that ...
user avatar
  • 1
0 votes
0 answers
4 views

Conditional formatting for column

So I have series of columns ranging from row 2 to row 42. I would like the cells in each column to recognize when a cell in the column has a value in it. When a cell in a column gets a value most ...
user avatar
0 votes
1 answer
21 views

Highlight Cells Using Conditional Formatting Based on Other Cells Value

I am having some issues with making some conditional formatting work - I'm trying to Highlight the cells in paris - H&I and J&K based on what is in cell L - If L contains the word "...
user avatar
  • 1
0 votes
0 answers
28 views

Conditional formatting help with multiple conditions

I have a makeshift production calendar in google sheets that has the date range of product needed and the color of the product (in a drop down list from another sheet. I want to have conditional ...
user avatar
  • 1
0 votes
1 answer
30 views

Highlight value in column based on list of values in other column that's on the same line as another value

Is that subject confusing enough? Here's my spreadsheet: https://docs.google.com/spreadsheets/d/1pksa5_7R2TuPaufIS8mPl6gxZ8aPoMdEfkebKsx1YKI/edit?usp=sharing It's for calculating speed@RPM for an ...
user avatar
0 votes
0 answers
52 views

How to make a macro in Google Sheets that runs when a cell changes value and then formats a range based on the value in the cell

I have some formulas that pulls out data for different graphs in Google Sheets. These data can either be in full numbers (e.g. Revenue) or in %. I have a dropdown for each graph where the user can ...
user avatar
0 votes
1 answer
15 views

I am trying to figure out how to change a column of many dates so that any date that is "less than" 1/1/2021 will automatically change to 1/1/2021

I have the conditional formatting set to change the color of the cell. But I need the actual value to change to 1/1/2021. But only if it's less than. If it's more than that, then I don't want it to ...
user avatar
  • 1
1 vote
1 answer
86 views

What's the "if text contains" formula in Google Sheets?

To be specific, I want when I enter box C1 with a value like "done" both cell B and C will be colored green. For this I already did =$C1="done" Tho this time I want it to change ...
user avatar
0 votes
0 answers
17 views

Google Sheets Conditional Formatting for Expiration Dates with Colors

I need to create conditional formatting for expiration dates of gift certificates: Gift certificates are valid for 60 days. Cells should stay green between days 0-30 before expiration. Cells should ...
user avatar
0 votes
1 answer
30 views

Google Sheets Combining Is Between and AND operator Conditional Formatting

my programming knowledge is not great and I need some help. I am trying to get conditional formatting to highlight any cell in a column that contains values between 13-16 AND in a different column (...
user avatar
0 votes
1 answer
51 views

How do you utilize conditional formatting for times over multiple days in Google Sheets

I am trying to visually see when events are taking place on our site. I have a list of events, their start date/time and end date/time. I would like to create a visual such as a Gantt chart that shows ...
user avatar
  • 1
0 votes
0 answers
17 views

Google Sheets. Conditional changing colur of text

I have a spreadsheet for a doing a monthly roster for a volunteer group. Column A contains the volunteer names & Row 1 contains the days of the month. I email out a request to volunteers to ask ...
user avatar
  • 1
0 votes
1 answer
23 views

Highight cell based on current time

Working on an hourly To-Do list. I have a column (H) with the list hour (on the Hr) starting with 5am all the way until 11pm. For Example: 5:00 AM 6:00 AM 7:00 AM 8:00 AM and so on.... I would like ...
user avatar
0 votes
1 answer
17 views

Conditional formatting across documents

I run several youtube channels and have an upload schedule for each. I also have a master schedule that shows uploads across all channels. Each of these are different sheets within separate documents ...
user avatar
  • 1
0 votes
0 answers
15 views

Highlight 3 cells based on date in one of the cells to be highlighted

To start off I am using google sheets. I am looking for some help on this one as have been trying and searching the internet for different conditional formattings which aren't working. I have 3 cells ...
user avatar
  • 1
0 votes
1 answer
26 views

How do I conduct conditional data validation multiple times so that each input prompts a different conditional validation outcome

I am a member of a project that does electricity monitoring, and I am trying to organize our contact sheet to indicate the status of our electricity monitoring across locations. I want to make the ...
user avatar
0 votes
2 answers
52 views

"Marking" or "tagging" noncontiguous cells for later use in a formula

Is there is a way to 'mark' a cell (or a set of cells) throughout a worksheet or workbook in Google Sheets, such that I can perform operations on these easily later. The real world application of this ...
user avatar
0 votes
1 answer
26 views

highlight cell in column B on every first not empty cell in following columns

I'm working on a medicine sheet, where I want to highlight the times when a pill is added to one of the following columns. Right now it looks like this: Each pill works for (about) 7 hours, so I take ...
user avatar
1 vote
1 answer
17 views

Conditional Formatting Help

I must be having an off day as I'm usually good with formulas - but I'm trying to finalize something for work and my brain is not getting me there.... I need a formula to color cell G75 Orange if cell ...
user avatar
  • 11
0 votes
1 answer
14 views

Conditional formatting from another google sheet

I am trying to create a conditional format for a cell to turn red, if that value is less than the value of another cell on a separate sheet. Does anybody know how to do this?
user avatar
0 votes
2 answers
62 views

Conditional Formatting 'Blocks' of cells

I am wondering if it's possible to use a custom formula in conditional formatting to highlight a single 3x3 block of cells - rather than a single cell, an entire row/column, or the entire range - ...
user avatar
0 votes
0 answers
22 views

Change cell colour in mastersheet if cell in secondary sheet contains any text

I'm new to this and trying to find a way to change the cell colour of a mastersheet in my schedules document on the basis of an individual schedule in a different sheet containing text (any text) in ...
user avatar
  • 1
0 votes
1 answer
52 views

Google sheets conditional formatting to show selected text

So i've been trying to find a way to do this but struck a wall so hoping someone here might have a idea! Problem: We have a list of signatures that can be choosen with dropdown list in Google sheets. ...
user avatar
0 votes
0 answers
15 views

Conditional Format cell if the value is just text or a reference [duplicate]

How to Conditional Format cell in Spreadsheet based on whether the value is just text or a referenced cell from another tab
user avatar
0 votes
1 answer
30 views

Google Sheets- How to format a cell to change color on a future date

I'm trying to format a cell in google sheets to change colors when it reaches a certain date. For example, if I call a customer on 10/10/2021, I want to format a cell in the row to turn red on 10/20/...
user avatar
-1 votes
1 answer
36 views

How can I conditionally format this Google Sheet with multiple IFTHEN

I'm collaborating on a Google Sheet with approximately 500 rows. I think potentially could use IF, ISBLANK and conditional formatting but I can't conceptualize a formula for this and I've tried ...
user avatar
  • 1
0 votes
1 answer
195 views

Google Sheets: One Conditional Formatting Color Scale Rule, for multiple independent rows at once?

Is there a way to use one single color scale conditional formatting rule for the whole sheet, that will separately compare only the values from each independent individual row? It seems that this can ...
user avatar
0 votes
0 answers
30 views

Colour scale for many rows independently once

I found a solution to colour scale many rows independently using the below script that I found in an answer from Oren Pinsky (thank you!), but can't figure out how to add the selected ranges in the ...
user avatar
0 votes
0 answers
10 views

How to convert all list styles in a Google Docs document?

I have a document with multiple numbered ordered lists throughout [1, 2, 3...] But I need to change the list styles to a different type of list -- for example [A, B, C...]. A visual example of what I ...
user avatar
0 votes
0 answers
47 views

Fill in one cell if another has had a date selected and move the row when the date is selected and subjected to an onEdit script

I have built a Google Sheet with a lot of data. I have also put in a script to sort data automatically, by date, when new information is input. The new information can relate to past, present or ...
user avatar
  • 1
0 votes
1 answer
215 views

Percentile Conditional Formatting in Google Sheets - Copying the formatting but isolating the range

I have setup conditional formatting using a green-red percentile color scale. This works fine until I copy this section down the sheet. When I do this, the numbers in the second section affect the ...
user avatar
0 votes
1 answer
70 views

Conditional Formatting Not Working On My Machine, But Does On Other Machines!

I hope someone can help me with my current issue. I have an issue that my Google Sheets are not working on my Windows computer, but do work when I use the Sheets with other computers! I make ...
user avatar
0 votes
1 answer
99 views

Google Sheets - Return a text value based on another cells text value

I have a set group of "program names" in a column, and want to have another column automatically write the matching "acrononym" for its sister value. For example: Master in Finance ...
user avatar
0 votes
1 answer
23 views

Having some problems with conditional formatting in Google Sheets

So I have two sheets together and I'm trying to change the colour of a cell in one sheet based on if a range in the other sheet contains a certain value. For example, in sheet 1 I would like cell A1 ...
user avatar
  • 1
1 vote
2 answers
66 views

Transferring an Excel document to G Sheets, how do I fix the slightly broken auto-borders implementation?

I'd like to transfer this Excel spreadsheet to Google Sheets, maintaining the automatic background formatting functionality, particularly in the case of the borders. Here is the same spreadsheet ...
user avatar
  • 77
0 votes
1 answer
35 views

Google sheets conditional format to highlight a column containing items from another list

I have rows of data, Col. A will be the order number and there will be duplicates of the order number (this is for each individual item purchase and MUST NOT be removed to give unique numbers). Then I ...
user avatar
  • 189
0 votes
1 answer
48 views

Conditional formatting based on string values in another column

In Google Sheet I would like to highlight in red the cells in a column "Y" if another column, say column "X", contains certain abbreviation (string variable). Column "X" ...
user avatar
0 votes
1 answer
35 views

Google Sheets Conditionally format a range based on values from another range

I have a column/range of emails like: jschmoe@zzz.org vwilliams@zzz.org hpotter@zzz.org swilliams@zzz.org and a column/range of names like: jschmoe vwilliams tbrady rdowneyjr caguilera swilliams I'...
user avatar

1
2 3 4 5
9