Questions tagged [conditional-formatting]
For questions about conditional formatting in spreadsheets.
287
questions
2
votes
1answer
14 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 ...
0
votes
1answer
12 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", ...
1
vote
1answer
14 views
How to highlight cell if it's value is a multiple of a given number
I would like to apply conditional formatting to any cell within a range containing a value that is a multiple of itself.
IE: Apply bold font to any cell of column A that is a multiple of 4 (4,8,12,16,...
1
vote
1answer
27 views
How can I select all cells that contain specific text in Google Sheets?
I have a spreadsheet that contains 20,000 cells.
I want to select all cells that contain "foobar".
How can I do this?
1
vote
0answers
27 views
Conditionally format a column if it contains all the values in a set
Each of the columns in my Google Sheet represent a farm. Each farm is a list of animals. I want to highlight the entire column if the farm has a duck, a horse, and a cow. So the column may look like ...
1
vote
0answers
41 views
Conditional Formatting IF/AND Google Sheets
EDIT 2:
Test document. See comment of what I'm trying to accomplish in cell A1.
https://docs.google.com/spreadsheets/d/1lqrPbVqSrO257PqOYKLuCTxG1iiLaL6KYawp1hu4n5c/edit#gid=0
EDIT:
I've tried this ...
0
votes
0answers
5 views
How can I create conditional formatting based on a reference table?
I'm trying to format rows in my spreadsheet based on a single column (S), which is fine BUT S contains both the category and the status of the item in each row. I want to color the row based on the ...
0
votes
2answers
27 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 ...
1
vote
1answer
11 views
Conditional Formatting in Google Sheets not working correctly
I recently tried to edit the conditional formatting for a column that was working correctly before and then change it back to the same exact formula it had before and now it isn't working correctly. ...
0
votes
1answer
25 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 ...
1
vote
1answer
9 views
Highlight data that match with data from other sheet
I have two tabs in a Spreadsheet. Both are having a list of data. I want to highlight cells in one tab that match with cells from another tab.
For example:
Tab 1
Column 1
ABC
XYZ
PQR
DEF
Tab 2
...
0
votes
0answers
27 views
Create conditional formatting for a table in google docs
So maybe someone can help me out with this. I have a Google sheet that I merge using AutoCrat to a google doc. The doc has 3 tables and one is priority - red, yellow, green. I am trying to put ...
0
votes
1answer
8 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.
2
votes
1answer
18 views
How to make a cell highlight red if its less than 6 digits and NOT effect blank cells?
I use this function
=LEN(P3:P)<6
in order to highlight all the entries with less than 6 digits (6 is minimum)
However, all the blank cells also highlight red. What function do I have to do in ...
1
vote
1answer
19 views
AND / OR Conditional Formatting for Google Sheets with multiple criteria
I am trying to write a custom formula to conditional format column E by referring to the different tenure level targets in column D to indicate if they are hitting their targets base off of their ...
0
votes
1answer
15 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".
1
vote
0answers
10 views
Conditional Formatting formula for alternating checkerboard with Merged Cells?
I wrote a formula that attempts to create a checkerboard pattern via conditional formatting, that should even work with Merged Cells. However, it seems to fail in an almost undebuggable manner with ...
2
votes
1answer
19 views
Google Sheets date conditional formatting
I have dates in column D in Google Sheets. I want the cells to highlight red if 30 days have passed and there is not a comment date in column F.
Example:
Column D: Submittal Date 6/29/2019
...
0
votes
2answers
26 views
Format Cells if greater than “value of the cell”
Values of K11–K13 are variables. On the Conditional formatting, I want to use the output from those cells in the "Greater than" function. Typing =k11 doesn't work. I'm not really sure on how to do it. ...
0
votes
1answer
18 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
12 views
Conditional formatting on whether something is a formula in Google Sheets?
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?
1
vote
1answer
22 views
Conditonal Formatting if cell A is within a range of numbers to make cell B a different color
I am looking to create a conditional format that if a cell "A" is within a range of two numbers that cell "B" will then change color in Google Sheets. Please help.
1
vote
1answer
28 views
Entire Column green if all cells in it are empty
I would like all columns that only contain empty cells to light up green.
In the below picture these should be: C3:C8, D3:D8, E3:E8, L3:L8
What would be the correct custom formula for this?
Bonus ...
1
vote
1answer
37 views
Adding date picker to Google Sheets cells while data validation is customized
I have a column with customized data validation (custom formula) that accepts only dates, provided that a few other conditions are met.
How can I add a date picker to the cells of this column? ...
2
votes
1answer
19 views
IF AND not working in Google Sheets for Conditional Formatting
I am trying to use the three following functions...
=IF(AND(M3="Funding on Hold",R3>=3,R3<=6),TRUE,FALSE)
=IF(AND(M3="Funding on Hold",R3<=9,R3>=7),TRUE,FALSE)
=IF(AND(M3="Funding on Hold"...
1
vote
1answer
11 views
Create list by cell color
I have a master list of trading cards. I'd love to be able to use a color coding system. For example, if Green is cards I've already collected, when I highlight the background of the cell green, I ...
0
votes
2answers
10 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....
1
vote
1answer
21 views
Dynamic Master sheet that grabs red formatted cells from another sheet
The title may be a little too ambiguous but I'll try to give a rundown as best I can;
I have a Google sheet with multiple "Sheets" or Tabs (as I'd like to call them) within it.
The Main tab is blank ...
1
vote
1answer
24 views
Google Sheets color row if date is closest to today's date
If possible, I would like to have a color schema applied to the table.
For instance, the cell that has the closest date to today will be green
The cell that has the furthest date to today will be red....
1
vote
1answer
18 views
Google Sheets Conditional Formatting Formula
I am doing a formula in conditional formatting and I need it to be relative to each of the 1500 rows but it keeps retrieving an absolute value. how do I get around putting a new formatting formula for ...
1
vote
1answer
93 views
Google Sheets Conditional Formatting not working for all cells
This is my first question using StackExchange, so please bear with me. I am making a spreadsheet for tracking due dates for training. Sheet 1 shows due dates that people with view only capabilities ...
2
votes
1answer
21 views
Date highlighting of a cell, separated by weeks, given only a starting date and a cell range
I am trying to build a "life calendar" similar to this - https://labs.coruscantconsulting.co.uk/life/weeks/ - in Google Sheets.
I have the manually designed sheet finished, but want to add the ...
1
vote
1answer
19 views
Google Sheets Conditional Formatting custom formula not working
I am trying to shade all rows that are associated with a specific value of column B as =$B2="BAMS", yet custom formula keeps saying the wrong formula.
Any idea?
1
vote
1answer
25 views
Google Sheets conditional formatting for Max value that meets a second condition
I'm working with a baseball statistics spreadsheet in Google Sheets, and I want to highlight the maximum value in my batting average column, but only if that value is for a player who has satisfied ...
0
votes
1answer
19 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 ...
1
vote
2answers
38 views
Conditional Highlight: color change cell only if multiple others filled in
I have a shift sign-up sheet in which I would like the cells in column A to be highlighted only once there is a value (name) in the corresponding cells in columns B:D.
In this example, I would like ...
1
vote
1answer
18 views
Conditional formatting cells with multiple conditions and relative references over a range
I have a Google spreadsheet with arbitrary data. Three adjacent columns (let's say A, B and C) have been set up with Data Validation to only allow values from 1 to 10.
I'm looking for a way to ...
0
votes
1answer
12 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 ...
-1
votes
2answers
77 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.
0
votes
0answers
22 views
Google Sheets Conditional Formatting match multiple items in cell (csv)
I have the following data in Google Sheets:
A E
my my
dog great,foo
is
great paris,dog
foo
bar bar,car
cat
I'm trying to do a format rule that highlights a cell, which DOES NOT ...
0
votes
2answers
34 views
Google Sheets Conditional Formatting
I am trying to make a certain cell on my sheet light up based on what week it is.
Each cell contains the value Week X where the X is a week-number.
After a little bit of experimentation I have made ...
0
votes
0answers
33 views
How to colorized a cell in green when I choose YES from a select list in the same cell (in ETHERCALC)
In EtherCalc, I use a select
the A1 cell: =SELECT("YES","YES,NO,MAYBE")
Here is the A1 cell: =SELECT("YES","YES,NO,MAYBE")
And I'd like the A1 cell to become green when I choose YES or to become when ...
0
votes
1answer
19 views
Change Colors of Cell per Day based on Date in Cell
I'm new to Google Sheets and need help with conditional formatting. I have Column C, RESPA DATE, that has a date that varies for each borrower. I want to change the color of the cells in Column D, ...
1
vote
1answer
28 views
How to change row colour depending on due date in a cell
I need a whole row to be red if the date in column C is older than today()
I have tried this basic formula
=C2:C<TODAY()
but that makes every row that is still empty also red.
So how to add ...
1
vote
1answer
19 views
Formula works in cells but not in conditional formatting
So, I have a Gantt chart style diary. I want to apply conditional formatting to any column whose date (in row 2), is a public holiday. There is a sheet called 'Public Holidays', that has the dates ...
0
votes
1answer
34 views
Simple Scorecard Conditional Formatting
I simply want to create a scoresheet comparing scores to par. If less than par then a red number, if more than par then highlight red, if equal to par then highlight green. Here is what I'm trying ...
0
votes
2answers
19 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 ...
2
votes
1answer
13 views
Format cell, If word from list in cell
I'm trying to color tag cells according to keywords they may contain. I've searched just about everywhere, and have tried various applications of the Search and Find functions to no avail.
Imagine I ...
1
vote
1answer
35 views
Disable Conditional Formatting without deleting the rules
I have multiple conditional formatting rules in one of my Google Sheets, I would like to disable a few of those rules for some time and would like to enable them again. But I don't see any such ...
0
votes
1answer
13 views
How can I conditionally format cells to denote past/future/current dates?
I have a church rota Google Sheet. Column A shows the date of each service.
To make it more obvious at a glance, I would like cells in column A to apply formatting so that dates in the past are ...
