Questions tagged [conditional-formatting]
For questions about conditional formatting in spreadsheets.
334
questions
0
votes
0answers
7 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
12 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
15 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
48 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
18 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
14 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
26 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
36 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
36 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
98 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
31 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
29 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
12 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
17 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
39 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
20 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
33 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 ...
2
votes
1answer
26 views
Is there a way to copy text from two cells into another spreadsheet only if another cell has a YES?
I want to copy the text in Cells A1 and B1 into another spreadsheet that will be emailed out, but only if the text in Cell E1 has a "YES" in it.
How would I go about doing something like this in ...
-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
26 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
17 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
0answers
154 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 ...
0
votes
1answer
131 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
30 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
38 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
111 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)?
1
vote
1answer
12 views
Copy conditional formula to separate columns GoogleSheets
I've got a simple conditional formula to make cell green if there is more than X not empty fields. It works fine but I need a way to copy that formula to other columns. When I do it the simply click ...
0
votes
1answer
23 views
Conditional formatting row of data based off of a date range
I have a bunch of entries in a sheet which are all between a range of dates, the two columns with dates are start_date (B) and end_date (C).
I already highlighted past time periods using;
=DATEDIF($...
1
vote
1answer
25 views
Formatting based on multiple cells and duplicates
I will try my best to explain the situation :
I have a sheet where we enter test data and serial numbers.
Column A is serial number
Column C is if the unit passed or not.
I currently have ...
1
vote
1answer
187 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 ...
0
votes
0answers
24 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 ...
2
votes
1answer
179 views
Apply conditional formatting to a blank cell if another cell in the row is not blank
I am trying to create an equation for conditional formatting that would highlight a cell that is blank if another cell in the same row is not blank (i.e. that row is being "used"). In the picture ...
1
vote
1answer
10 views
Conditionally format a range based on the value of a single cell outside of it [duplicate]
I am using conditional formatting with a custom formula. I want to highlight rows in the range A2:B11 if the values in $B2 (column B starting at row 2) is greater than the value in the cell D5.
I can ...
0
votes
1answer
75 views
Google Sheets - Conditional Formatting question
So I have it set that if a cell has a value of 0 to change the background to yellow. I want to have it so that if there are two 0's (zeros) next to each other in a row (edit: in adjoining cells not ...
0
votes
1answer
24 views
Formatting a cell based off of the rest of the row
I have a spreadsheet keeping track of the various documents that students of mine have been turning in. The first column contains names and each column after tracks a particular document.
Is there a ...
0
votes
1answer
31 views
Comparing cell value 450-500 to another cell of value 475 in Google Sheets
I wanted to compare the price range column which will have prices range like 450-500 to another cell value 703.
In this image you can see I need to find column D value (which is the price range) to ...
1
vote
1answer
29 views
Using a custom formula as part of a conditional formatting rule
Ive got a spreadsheet with 3 columns A, B, C, i want to add the 3 columns together in column E, if there is a value in column C, i want the summed number to be shown in red.
If there is a value in ...
3
votes
2answers
54 views
Conditionally formatting a column based on content of nearby column
I am trying to get cells in column C to turn green when the cell in the same row of column B has a value in it.
I think there is a bug because the custom formula below is not working.
1
vote
1answer
27 views
Google Sheets conditional formatting with AND for value range
I'm trying to set a colour range of conditional formatting based on another cells value. So if A1 is larger than A2 it will be Blue, if A1 is between 0 and A2 it will be Yellow and if A1 is less than ...
0
votes
1answer
30 views
Highlight row if partial text matches in either of two columns
I have a sheet that has a list of job names, and then the last failure and success of each job. The dates are listed with duration words instead of dates, ie 1 mo 12 days or 3 days 6 hr.
I want to ...
1
vote
1answer
27 views
How do I make the “Text contains” evaluate any word written in the cell?
I just want the cell in Google Sheets to change its fill color when any text is inputted in the cell? But it has to be text excluding numbers. Please help!
1
vote
1answer
511 views
Finding merged cells in Google Sheets
I'm often trying to freeze columns in a Google Sheets and I get the error as below
The way I get around this is to manually hunt for the merged cells and unfreeze them, but this can be difficult on ...
-1
votes
2answers
56 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 ...
2
votes
1answer
57 views
Conditional Formating for Google Sheet comparing to list of text (highlight duplicates)
I am trying to create a custom formula for conditional formatting. I want to highlight the cell if the text appears in a list of names. This list will contain 210 unique names so I can't type each one ...
