Questions tagged [conditional-formatting]

For questions about conditional formatting in spreadsheets.

Filter by
Sorted by
Tagged with
2
votes
1answer
12 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", ...
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 ...
1
vote
2answers
3k views

How to use AND in Google Sheets w multiple criteria

What is the proper syntax for using AND, when creating a custom formula in Google Sheets? (The formula applies to a format I set in the Conditional Formatting interface.) H2:H2000 is greater than ...
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
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
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?
2
votes
1answer
499 views

How to highlight entire row (conditional formatting) using COUNTIFS

For the range C2:Z100 we apply the following formula to find duplicate students' enrollments using conditional formatting: =COUNTIFS($C:$C,C2 , $D:$D,D2)>1 (where column C is the last name and D ...
0
votes
1answer
965 views

Google Sheets Conditional Formatting Isn't Working

I am making a spreadsheet in Google Sheets and my conditional formatting works in some cells and not in others. I have gone so far as to delete all of the formattings for the entire workbook and ...
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
26 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
2answers
861 views

Conditional Formatting based on other column

I have a timesheet log with columns DATE | HOURS | DESCRIPTION OF WORK | PROJECT An employee may enter several rows for the same date to log the different amount of time with respect to the ...
1
vote
1answer
16 views

Conditional Formatting Duplicate Invoices in Google Sheets

My workplace uses Google Sheets to track invoices across all locations. The two most important columns are next to each other and titled Invoice number and Vendor. I wanted to highlight the Invoice ...
0
votes
1answer
113 views

Max value conditional formatting rule not working in Google Sheets

I want the max value in Column B to show up. I put in this formula but it's not working. What am I doing wrong? Here is the table
0
votes
1answer
16 views

Quick way to make an automatically color-coded Google sheet for every day of the year?

So if the day is January 1st, the cell will be one color. If it's January 2nd, it'll be another color, and so on for every day of the year. Is this possible?
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
10 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 ...
0
votes
0answers
26 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 ...
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
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".
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
73 views

Date fields that refuse to be parsed/formatted

I have some very mysterious date fields in a huge (600 000 records) CSV file which absolutely refuses to behave. They come up aligned left, and conditional formatting shows that they cannot be seen ...
1
vote
1answer
18 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 ...
1
vote
1answer
134 views

Combine Custom Formula with Colour Scale in Conditional Formatting

In Conditional Formatting in Google Sheets, I'm wondering if it is possible to combine the Format Cells if - Custom Formula is with a Colour Scale? It would appear not, but is there a clever ...
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
0answers
9 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 ...
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. ...
9
votes
5answers
25k views

How to create a checkbox column, that if selected will create a strike-through across the entire row in Google Sheets?

I have a Google Sheets. I want to set it up so that the first column is checkboxes, and if the checkbox is selected, the entire row gets a strike-through. How can I accomplish this? I followed this ...
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
2answers
137 views

What function can I use to conditionally format text depending on cursor position or active cell?

In Google Sheets, I have a 'Freeze' on Column A. I want the text in Column A, Row X to Conditionally Format as BOLD RED, while my cursor is on any cell for Row X. Is there a way to manage that?
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 ...
0
votes
2answers
3k views

Identifying a merged cell in Google Sheets without using a custom function

I am using Google Sheets and I am trying to find a way to identify merged cells without using a custom function. For example, I need to determine (using only the built-in functions) whether any ...
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? ...
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
307 views

Conditional formatting by using the note in Google Sheets

How can I use conditional formatting by using the note on a specific or many cells in Google Sheets? For example, I would like to set up conditional formatting to a specific cell and when I use a note ...
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
1answer
231 views

Google Sheets Conditional Formula

Google Sheets formula for outputting PASS or FAIL in one cell based on the color (green or red) of another cell?
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
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
1answer
549 views

Can I use conditional formatting to highlight a cell for dates less than 30 days away?

I have a large spreadsheet where I need to keep track of coming expiration dates and I would like dates which are within 30 days from today's date OR which have already passed to be highlighted in red....
1
vote
1answer
860 views

Colors in conditional formatting based on cell hex values [duplicate]

I am looking for a solution to change the background and font color of a cell based on hex-values in another cell. I am managing a google spreadsheet for an online basketball league. I have several ...
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
17 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 ...