Questions tagged [conditional-formatting]

For questions about conditional formatting in spreadsheets.

94 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
5answers
16k 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". In other words, I want to highlight them so that they can be copied, formatted, etc. How ...
3
votes
2answers
570 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 ...
3
votes
3answers
360 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 ...
2
votes
1answer
3k views

How can I get a cell to change its value based on another cell's color?

I have three colors in column F: green, grey and red. What I want is for column G to display a number (1, 2, 3) depending on the color value of F. Is there a way to do this?
1
vote
1answer
15 views

Conditional Formatting Help

I must be having an off day as I'm usually good with formulas - but I'm trying to finalize something for work and my brain is not getting me there.... I need a formula to color cell G75 Orange if cell ...
1
vote
0answers
26 views

Google Sheets conditional formatting adapt to value

I'm currently working on a Google Sheet which tracks hourly performance, the layout is basic which is hours against units completed. The conditional format I already have in place works for a time ...
1
vote
1answer
37 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 ...
1
vote
0answers
13 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 ...
1
vote
0answers
104 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, ...
1
vote
0answers
18 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
2answers
137 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/...
1
vote
1answer
2k 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 ...
1
vote
1answer
334 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 ...
1
vote
1answer
145 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
1answer
57 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
2k 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 ...
1
vote
2answers
353 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
1k views

How do I conditionally format text color to match across sheets in Google Sheets?

Edit: I couldn't figure out how to post pics without editing, so I added them to the OP. The first photo is the process form. On the form, as the boxes are checked the color changes from black to red ...
1
vote
1answer
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 ...
1
vote
2answers
2k 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
596 views

Conditional format custom formula in Google Sheets

Have a question on how to do a custom formula in conditional format for the following: A1 = DCC220 B1 = 7.50 C1 = 7.00 D1 = 7.60 I want to compare the result in B1 (7.50) to a range, C1 lower, D1 ...
1
vote
1answer
21 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
0answers
12 views

How to make a macro in Google Sheets that runs when a cell changes value and then formats a range based on the value in the cell

I have some formulas that pulls out data for different graphs in Google Sheets. These data can either be in full numbers (e.g. Revenue) or in %. I have a dropdown for each graph where the user can ...
0
votes
0answers
8 views

I am trying to figure out how to change a column of many dates so that any date that is "less than" 1/1/2021 will automatically change to 1/1/2021

I have the conditional formatting set to change the color of the cell. But I need the actual value to change to 1/1/2021. But only if it's less than. If it's more than that, then I don't want it to ...
0
votes
0answers
12 views

Google Sheets Conditional Formatting for Expiration Dates with Colors

I need to create conditional formatting for expiration dates of gift certificates: Gift certificates are valid for 60 days. Cells should stay green between days 0-30 before expiration. Cells should ...
0
votes
1answer
16 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 (...
0
votes
0answers
16 views

Google Sheets. Conditional changing colur of text

I have a spreadsheet for a doing a monthly roster for a volunteer group. Column A contains the volunteer names & Row 1 contains the days of the month. I email out a request to volunteers to ask ...
0
votes
1answer
15 views

Highight cell based on current time

Working on an hourly To-Do list. I have a column (H) with the list hour (on the Hr) starting with 5am all the way until 11pm. For Example: 5:00 AM 6:00 AM 7:00 AM 8:00 AM and so on.... I would like ...
0
votes
0answers
15 views

Highlight 3 cells based on date in one of the cells to be highlighted

To start off I am using google sheets. I am looking for some help on this one as have been trying and searching the internet for different conditional formattings which aren't working. I have 3 cells ...
0
votes
1answer
23 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 ...
0
votes
1answer
13 views

Conditional formatting from another google sheet

I am trying to create a conditional format for a cell to turn red, if that value is less than the value of another cell on a separate sheet. Does anybody know how to do this?
0
votes
0answers
21 views

Change cell colour in mastersheet if cell in secondary sheet contains any text

I'm new to this and trying to find a way to change the cell colour of a mastersheet in my schedules document on the basis of an individual schedule in a different sheet containing text (any text) in ...
0
votes
1answer
20 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/...
0
votes
1answer
67 views

Google Sheets: One Conditional Formatting Color Scale Rule, for multiple independent rows at once?

Is there a way to use one single color scale conditional formatting rule for the whole sheet, that will separately compare only the values from each independent individual row? It seems that this can ...
0
votes
0answers
21 views

Colour scale for many rows independently once

I found a solution to colour scale many rows independently using the below script that I found in an answer from Oren Pinsky (thank you!), but can't figure out how to add the selected ranges in the ...
0
votes
0answers
6 views

How to convert all list styles in a Google Docs document?

I have a document with multiple numbered ordered lists throughout [1, 2, 3...] But I need to change the list styles to a different type of list -- for example [A, B, C...]. A visual example of what I ...
0
votes
0answers
31 views

Fill in one cell if another has had a date selected and move the row when the date is selected and subjected to an onEdit script

I have built a Google Sheet with a lot of data. I have also put in a script to sort data automatically, by date, when new information is input. The new information can relate to past, present or ...
0
votes
1answer
49 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 ...
0
votes
1answer
15 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 ...
0
votes
1answer
37 views

Conditional formatting based on string values in another column

In Google Sheet I would like to highlight in red the cells in a column "Y" if another column, say column "X", contains certain abbreviation (string variable). Column "X" ...
0
votes
1answer
29 views

Google Sheets Conditionally format a range based on values from another range

I have a column/range of emails like: jschmoe@zzz.org vwilliams@zzz.org hpotter@zzz.org swilliams@zzz.org and a column/range of names like: jschmoe vwilliams tbrady rdowneyjr caguilera swilliams I'...
0
votes
0answers
37 views

Excel 365 conditional formatting colors

How would I go about adding more color formatting options to the circled list? I have more points to highlight that options it has. Plus some of the options look to similar to me.
0
votes
1answer
24 views

Find or search in the custom formula used by conditional format

Is there any method for searching formula in conditional formatting? 'Find and replace' menu only can search formula in cells. I want to remove a range of cells but i don't want to break a conditional ...
0
votes
1answer
68 views

Conditional formatting with dates in Google Sheets

I'm trying to add a little functionality in my register to help me catch incorrectly entered dates. I've got a column, A, for dates where no date entered should be earlier than the previously entered ...
0
votes
0answers
13 views

How to manage many conditional formats?

I have a lot of conditonal formatting and start to become complicated to manage. Is there anyway i can give it a 'name' or make a label or something like that? And there's no disable funtion , so ...
0
votes
1answer
13 views

How to flag duplicate items within the same 'group'?

I have this table : So I have the days column and fruit column. There's grouping based on days : Monday, Tuesday , Wednesday etc indicated by that grey and light blue color to separate each day. The ...
0
votes
0answers
16 views

Conditional Formatting if there is text in next cell

I have a spreadsheet where we track chasing people for figures. Client name Date to chase 1st chaser 2nd Chaser 3rd chaser the first chaser box for each client is empty till we do it ...
0
votes
1answer
60 views

Create a RAG system based on dates, upcoming and expired within Google Sheets

I want to create a RAG system in google sheets based on dates in a cell. Column A will show a date when someone is trained on a topic and column B shows the due refresher date (3 years later). I want ...
0
votes
0answers
60 views

Add more conditional formatting cell highlight color options in excel online

In excel online (such as a spreadsheet tab in teams), you can add conditional formatting to highlight a cell that contains a certain value. But there are very limited options for highlighting colors ...
0
votes
0answers
25 views

Google Sheets formatting

I have a workbook in Google Sheets and it is for a schedule for my company so I have a few sheets in my workbook that have the days of certain weeks and then one more tab that has inventory ...