Questions tagged [conditional-formatting]
For questions about conditional formatting in spreadsheets.
347
questions
0
votes
1answer
16 views
Conditional formatting to highlight values that are not in valid date format
I have a Google Sheets spreadsheet with a date column. A contributor to this spreadsheet keeps entering dates in invalid format. I would like to conditionally format the cells in this column to have a ...
1
vote
1answer
23 views
How do I conditional format a table in Google Sheets based on two other cell values?
In the scenario below, the table contains random integer values.
I want to use conditional formatting in order to highlight the values in the table between the specified min and max values.
While I ...
1
vote
0answers
10 views
Is it possible to format row fill colour by a cell in an expandable way? if new job number, new row colour
I keep a to do list.
Each row has a job number.
There are several entries for each job number.
I'd like to ask google sheets to look at the job number in column. Give the row a colour.
Every time a ...
0
votes
1answer
12 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 ...
1
vote
1answer
39 views
Isolating conditional formatting to each range in a column
I've set up conditional formatting to highlight the top 3 values (gold, silver, bronze) in a range of rows. However, I want to be able to copy/paste the conditional formatting below the initial rows ...
0
votes
1answer
17 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 ...
1
vote
0answers
18 views
Google Sheets conditional formatting multiple columns based on value relative to 1 column
I have a reference column of values (column A & B) and then all subsequent pairs of columns that get added to sheet, I want to highlight their value in relation to those two. So column C values, ...
0
votes
0answers
20 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 ...
1
vote
1answer
15 views
Color a cell if the text inside it is not the first time it has appeared on the sheet
In cell A1 I have the text "hello".
In cell A2 the text "hello" appears again.
In cell A3 I have the text "goodbye".
In cells A4:A10 the text "goodbye" appears again.
Is there are a way (with ...
-1
votes
1answer
25 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 ...
0
votes
0answers
14 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 ...
1
vote
0answers
12 views
Conditional format using the IF function
I'm trying to use a conditional format using the IF function to determine if a value needs a dropdown menu.
Example: if A1=book, then provides a list of authors to choose from; the same if A1=car, ...
1
vote
1answer
15 views
How to get conditional formatting in Google Sheets if a cell contains specific formula/function?
I would like to set conditional formatting in my GS for cells that not only are a formula, but have a specific type of formula.
I know I can do a conditional formatting to highlight cells that are ...
1
vote
1answer
24 views
Conditional Formatting w/multiple conditions and partial text match
I am working in google sheets and have a manual input quantity in column E. I am trying to write a conditional format that will highlight each cell in column E (or the whole row) that is greater than ...
0
votes
1answer
15 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 ...
1
vote
1answer
46 views
Google Sheets Conditional Formatting based on Text and another cell
I'd like to color code a sheet based on two criteria: If the cell in the range contains specific text "A1" and if another cell, $X$7, contains an X or is not blank. I can't seem to get AND or IF or ...
1
vote
1answer
22 views
How to highlight cell if any of 6 cells to the right not blank
I would like to highlight the value in column D if any of the cells in the same rows from columns E:K are not blank. I have tried this formula in custom formatting:
=NOT(ISBLANK($E137:K137))
This ...
0
votes
1answer
22 views
How can I have conditional formatting with lower priority than manual formatting
I know how to do the formatting that I want. The document should have conditional formatting. However When I added it. It covered the manual formatting.
It there a way to say do this conditional ...
0
votes
1answer
16 views
Is it possible to highlight the minimum value in a table on Gsheets?
I am currently compiling a table of pace per minute on this Gsheet.
I am looking to conditionally format the cells to highlight the minimum and maximum but cannot seem to find a formula for this ...
0
votes
0answers
20 views
How can I highlight a cell if another column contains the same text?
I have a spreadsheet containing a list of names in column A. I also have a list of names in column C. I'd like to create a conditional formatting formula to highlight any cells in column A that ...
0
votes
1answer
17 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 ...
1
vote
1answer
17 views
How to check and replace cells
I need help trying to figure this out. I am extremely new to formulas and very confused.
Here is my thought process:
IF B1 contains a comma AND C1 is exactly "none" THEN I want C1 to be replaced ...
1
vote
1answer
121 views
Conditional formatting on merged cells
The situation - I have rows of data where similar names are grouped and merged to show all those rows are for the same individual like so:
Now I'd like to have conditional formatting where say if the ...
0
votes
2answers
24 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
0answers
19 views
Conditionally format by hours of operation
I'm trying to understand what percentage of my leads come in during business hours v.s. times when we are closed. the timestamp I get from our lead spreadsheet is "YYYY-MM-DD HH:MM:SS" So far I've ...
0
votes
1answer
23 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
votes
1answer
15 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 ...
0
votes
0answers
29 views
Simplifying Custom Formulas in Google Sheets
I wanna know if there is an easier way to do this.
I have a custom calendar and there are 4 conditions for every day.
You can see the example.
All those cells are colored based on a condition.
...
1
vote
1answer
40 views
Fill in red if cell is not today
I am new to Google Sheets, excuse me for a (most likely) dumb question.
I have a column with dates looking like 03.03.2020.
What formula do I use to fill the cells with values not equal to today date ...
0
votes
0answers
9 views
Remove text from all cells in a column after matching the criteria using conditional formatting
Can someone help me with the formula that can be used in conditional formatting.
Let say I have a Cell R2=HOL and I want all the content from column 'R7:R12' to be deleted after matching condition ...
1
vote
2answers
47 views
Conditionally format if date is same/greater or smaller than current date
I'm trying to get my Google sheet to automatically colour a cell red if the current date is the same or greater than the date in the cell.
Example: today is 21/02/2020.
The date in the cell is 25/...
2
votes
2answers
373 views
Conditional formatting for cells that have date/time within the last 24 hours
I have a Google sheet that has a column for "last updated" and each row represents a separate file. People manually paste in the time and date in that column, like in the screenshot.
If the date and ...
1
vote
1answer
33 views
Conditional Formating if cell contains certain characters
I need to come to a custom formula in Google sheets that highlights a cell in the column if the cell contains certain characters in Cyrillic letter.
Some of the Cyrillic characters that look like ...
0
votes
0answers
18 views
My conditional formatting 'equal to' not working
I am trying to show a particular entry is equal to or greater than another entry by having the condition turn the cell green. But nothing I am trying is working. All other formatting works but when I ...
0
votes
1answer
58 views
How do I make the color of a cell change if the value has been modified in Google Sheet?
Basically, if the person enters "12" in his/her column, how can I make the cell change to a different color when the same person changes the value again?
This would let other people know if there ...
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
24 views
Google Sheets Formula - Trying to Sum, based on multiple cell criteria
I am looking for help with Google Sheets formula.
The formula I need is -
If A:A=LG and F:F=Indexed then sum the total of P:P for all of those instances.
If A:A=PG and F:F=Indexed then sum the ...
1
vote
1answer
142 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
0answers
26 views
Change the colour of a cell based on if the checkbox below an identically named cell on another sheet is true (Google Sheets)
This is something I've been struggling with for a little bit and don't know if its even possible. I would expect this to take likely hundreds of separate condition formatting rules but wanted to see ...
0
votes
1answer
36 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 ...
-1
votes
1answer
29 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
vote
1answer
27 views
How do I use conditional formatting on one column based on certain characters in another column?
When column D has a hyphen (-) in it, I want the fill color in column H to change.
What is the custom formula for that?
0
votes
1answer
18 views
Google Sheets apply conditionnal formatting for each column
I'd like to highlight the max value in each column. Example :
A B C
1 50 12 60%
2 20 84 50%
3 38 20 15%
Here A1, B2, C1 will be highlighted. So I know how to do that for 1 ...
3
votes
2answers
262 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 ...
2
votes
1answer
29 views
What formula could I use for conditional formatting to highlight cells in Column B if the text in Column A has a link in it?
I want to easily see what text in Column A has a link in it by looking at Column B.
0
votes
1answer
24 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
190 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 ...
0
votes
1answer
39 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
2answers
51 views
Conditional formatting custom formula not working in google sheets
custom formula is: "=COUNTIF($B1:$B100,"month")>1."
I tried also:
"=COUNTIF($B1:$B100,"month")>1"
=COUNTIF($B1:$B100,"month")>1
="COUNTIF($B1:$B100,"month")>1"
I know it shouldn't work ...
0
votes
1answer
957 views
Is there a way to conditionally format border styles in Google Sheets?
The title says it all.
I have some conditional formatting rules, it seems I'm limited to some basic formatting options;
Is there any workaround to apply further formatting options (such as border)?
