Questions tagged [conditional-formatting]
For questions about conditional formatting in spreadsheets.
497
questions
0
votes
1
answer
25
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 ...
CommunityBot
- 1
1
vote
1
answer
78
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 ...
CommunityBot
- 1
2
votes
1
answer
1k
views
Conditional Formatting across a range of cells with a formula in Google Sheets
I have a calendar put into Google Sheets with the data put in as dates such as "9/24/2018".
I have a separate sheet with a data set that has rows that classes end such as "9/24/2018".
I want to ...
CommunityBot
- 1
1
vote
2
answers
99
views
Alternate colors with masked rows
In Google Sheets, it seems that masking an odd number of rows in a range somehow defeats the alternate color formatting (adjacent rows will occur with identical colors). Is there a workaround using, e....
CommunityBot
- 1
2
votes
5
answers
14k
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 ...
- 11
0
votes
1
answer
133
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 ...
CommunityBot
- 1
0
votes
1
answer
293
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 ...
CommunityBot
- 1
0
votes
1
answer
102
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 ...
CommunityBot
- 1
0
votes
1
answer
19
views
Can the formula of a cell be conditional based on the dropdown selection of another cell?
Is there a way to create a formula where D9 is included/excluded from the formula based on the answer to the dropdown selection of D13 (Financing Repairs? Yes/No)?
Spreadsheet
I've spent hours ...
CommunityBot
- 1
0
votes
1
answer
477
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 ...
CommunityBot
- 1
0
votes
1
answer
47
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. ...
CommunityBot
- 1
0
votes
1
answer
22
views
Applying custom conditional formatting to additional ranges
I have a sheet where I am applying conditional formatting to certain cells in column B to highlight the highest and lowest values with red and green, respectively. It works for the column in which I ...
CommunityBot
- 1
1
vote
1
answer
121
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 ...
CommunityBot
- 1
0
votes
1
answer
43
views
How do I check a set of numbers in different columns against numbers in different columns?
I am trying to make a Lotto checklist in Google sheets. I have my own numbers in 6 columns, A2:F5. And I have typed the winning numbers in H2:M2, 6 columns also, with 1000 rows.
Now I want to check if ...
CommunityBot
- 1
1
vote
2
answers
2k
views
Conditionally format cells that not match with range from Sheet2
I have two sheets in the same file where "sheet1" has cleaned up information and "sheet2" has the dump from my Jira. Now I am trying to compare Column F from sheet1 and sheet2 to ...
CommunityBot
- 1
2
votes
2
answers
2k
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/...
CommunityBot
- 1
-1
votes
0
answers
13
views
Automatically Format & Combine Cells [duplicate]
I have a pretty specific need and I’ve had a lot of trouble figuring how even to get started.
I have several columns of text. My goal is to combine them into one cell (per row), such that:
The first ...
- 1
0
votes
1
answer
337
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 ...
CommunityBot
- 1
0
votes
0
answers
11
views
Data validation with 2 conditions [migrated]
I am looking for a conditional formatting formula that validates two conditions from another sheet.
I have Sheet1 and Sheet2: Sheet2 has daily records of workers such as time in and off, Sheet2 ...
0
votes
1
answer
177
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/...
CommunityBot
- 1
1
vote
1
answer
42
views
Conditional formatting based on frequency
I have a range (A1:L200) that has only numerical values (0-37).
I have a formula that shows the frequency that each value appears:
=FREQUENCY(A1:L200, N1:N38)
How can I use this formula or something ...
- 13.2k
0
votes
1
answer
56
views
Choose top 5 scores from multiple columns with conditions
I am trying to automate a bowling statistics table. Each bowler has multiple games, one column for each.
The problem I am having is that I am using =J1>=LARGE($J$3:$K$22, 4) in conditional ...
CommunityBot
- 1
1
vote
1
answer
138
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 (...
CommunityBot
- 1
1
vote
0
answers
12
views
How to condition a cell on the response of multiple dropdown cells [closed]
I have multiple drop down cells relating to space available : cell 1 : length, cell 2 : width and a third one related to flateness.
I would like the options to make a cell green or red depending on ...
- 11
1
vote
1
answer
52
views
Highlight duplicate based on two columns
I have a spreadsheet of patient data (several thousand records) where I need a way to indicate whether there's a duplicate patient. We know there's a duplicate if the last name and the date of birth ...
CommunityBot
- 1
0
votes
1
answer
38
views
Conditional Formatting based on table data
I'm having a table (in this example) everyone should write their name behind the Fruit he likes most.
I'm creating a dropdown box based on all people who wrote their names anywhere.
Based on the Name ...
CommunityBot
- 1
1
vote
1
answer
16
views
Sytnax for conditional formatting in Google Sheets
I am trying to write a Google sheet to keep track of a certain financial situation.
I have four columns: one for money 'in', the next for profit, the next for loss, then a final outcome column.
In ...
CommunityBot
- 1
1
vote
2
answers
498
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?
CommunityBot
- 1
1
vote
2
answers
2k
views
Disable conditional formatting rules without deleting them
I have a Google Sheets document that is shared to other users. The spreadsheet contains a lot of conditional formatting rules that add significantly to formula re-calculation times.
I would like to ...
- 3,351
1
vote
1
answer
60
views
Notification IF a cell is highlighted by 2 conditional formattings
Is there a way to generate an alert or a notification WHEN a cell or some cells are highlighted by 2 or more different conditional formattings?
Making that the upper conditional formating overwrite ...
- 44.6k
0
votes
1
answer
617
views
How do I unlink two columns in Google Sheets in regards to conditional formatting?
This has to do with right-clicking at the top of a column in Google Sheets to add another column to the left or right. When I do this, the conditional formatting from the original column carries over ...
CommunityBot
- 1
0
votes
1
answer
185
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 ...
CommunityBot
- 1
3
votes
3
answers
523
views
Conditional formatting for columns, date & time specific?
I have uploaded 4.000+ Venmo donation data sets into Google Sheets for sorting, but the date and time is preset and looks like this:
2018-11-01T20:16:52
I have tried multiple approaches to sorting ...
CommunityBot
- 1
0
votes
1
answer
10
views
Conditional Format on Cost deviations
I am trying to find a way for a column to highlight when it is greater than a value pulled from a v look up formula. This is a cost deviations report for my business, so i would like the quoted cost (...
CommunityBot
- 1
0
votes
1
answer
44
views
Google Sheets Conditional Format to highlight specific pieces of text within a cell
Is it possible to condition format so that sheets will format specific pieces of text within a cell instead of applying formatting to the entire cell. Is this an option in sheets yet?
e.g If cell ...
- 13.2k
0
votes
1
answer
546
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?
CommunityBot
- 1
1
vote
1
answer
161
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 ...
CommunityBot
- 1
0
votes
1
answer
59
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 ...
CommunityBot
- 1
1
vote
1
answer
57
views
Why do conditional formatting rules based on date affect the wrong cells?
Here is a Google Sheet for our church rota - publicly viewable: https://docs.google.com/spreadsheets/d/1KODl9N_I3VeO0CKBrU_75GoQ5dBvUuSzx0FinNKf9zs/edit?usp=sharing
I have conditional formatting rules ...
CommunityBot
- 1
1
vote
1
answer
24
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 ...
CommunityBot
- 1
3
votes
1
answer
6k
views
Apply conditional formatting to a blank cell if another cell in the row is not blank
I am trying to create a formula for conditional formatting that would highlight a blank cell if another cell in the same row is not blank (i.e., that row is being "used"). The picture below ...
- 44.6k
0
votes
1
answer
28
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 ...
CommunityBot
- 1
0
votes
1
answer
99
views
How to copy/paste conditional formatting in Google Sheets (without including the original cells)
When I copy and "paste the conditional formatting only" option from one column to another (e.g. A1:A5 to B1:B5) the result is that for B1:B5 the conditional format range includes A1:A5.
How ...
CommunityBot
- 1
2
votes
2
answers
689
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 ...
CommunityBot
- 1
1
vote
1
answer
250
views
Compare Columns, Highlight Missing Values
I am looking to compare two columns, a "Roster" column and a "Present" column and highlight any missing values.
The "Roster" column is a fixed value, but the "...
CommunityBot
- 1
0
votes
1
answer
61
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 ...
CommunityBot
- 1
1
vote
1
answer
3k
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....
CommunityBot
- 1
1
vote
1
answer
174
views
How can I highlight a column of cells (H) if the date in the cell is more than a week old, and the cell next to it (I) is blank?
I'm trying to make a spread sheet to track open purchase orders. One PO per row. One column has the order date in it, and the next column has the receive date for the order. I'd like the cell with the ...
CommunityBot
- 1
1
vote
2
answers
57
views
Formula that looks for any matching substrings between two cells
In Google Sheets, I'm trying to compose a formula that compares the substrings in two cells.
Substrings in each cell are separated by a space.
The formula should return TRUE if any substring in one ...
2
votes
1
answer
3k
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 ...
CommunityBot
- 1