Questions tagged [conditional-formatting]
For questions about conditional formatting in spreadsheets.
440
questions
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&...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 "...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 (...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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?
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 - ...
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 ...
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. ...
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
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/...
-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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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" ...
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'...