Questions tagged [conditional-formatting]

For questions about conditional formatting in spreadsheets.

Filter by
Sorted by
Tagged with
0
votes
1answer
8 views

Whats the if text contains formula in google sheet?

to be specific, I want when I enter box C1 with a value like "done" both cell B and C will be colored green. For this i already did =$C1="done" Tho this time i want it to change ...
0
votes
1answer
62 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 ...
0
votes
2answers
2k views

Google Sheets - Highlighting Cells if they contain text from another range of cells

I want to highlight a cell in a column with a specific color if it contains any of the elements from a range of cells on another sheet. I believe I need to use 'custom formula is' with the INDIRECT ...
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
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 ...
1
vote
1answer
144 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 ...
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'...
-1
votes
0answers
21 views

Google Sheets formula help. How would I create a conditional format for any 2 dates in a row that fall between 30 days of each other?

How would I create a conditional format for any 2 dates in a row that fall between 30 days of each other for any employee based on the infraction type in column B, dates are in column A? Example if ...
0
votes
1answer
47 views

How do you utilize conditional formatting for times over multiple days in Google Sheets

I am trying to visually see when events are taking place on our site. I have a list of events, their start date/time and end date/time. I would like to create a visual such as a Gantt chart that shows ...
0
votes
1answer
235 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", ...
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
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
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 ...
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 ...
0
votes
1answer
14 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 (...
11
votes
3answers
19k views

How do I change a cell to the color of the hexadecimal value of a cell in Google Spreadsheets?

Based on my data, I calculated values of hexadecimal color codes. I want some cell (I don't care whether it's an empty cell at the end of the row or the same cell) to be the color based on the code. ...
0
votes
1answer
67 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 ...
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 ...
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
55 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 ...
0
votes
1answer
113 views

Google Sheets: Need conditional format formula to parse number-hyphen-number input into "2-Tuesday" type

I want to write a conditional formatting formula that will convert 1-3 to 1-Thursday, 2-2 to 2-Wednesday, 3-1 to 3-Tuesday, 4-0 to 4-Monday. The rationalization being I have a list of committee ...
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
14 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 ...
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
1answer
22 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
31 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.
0
votes
1answer
38 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
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
12 views

Conditional formatting across documents

I run several youtube channels and have an upload schedule for each. I also have a master schedule that shows uploads across all channels. Each of these are different sheets within separate documents ...
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 ...
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 ...
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 ...
0
votes
1answer
78 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
47 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 ...
0
votes
1answer
68 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 ...
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 ...
0
votes
2answers
36 views

"Marking" or "tagging" noncontiguous cells for later use in a formula

Is there is a way to 'mark' a cell (or a set of cells) throughout a worksheet or workbook in Google Sheets, such that I can perform operations on these easily later. The real world application of this ...
0
votes
1answer
34 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. ...
0
votes
1answer
25 views

highlight cell in column B on every first not empty cell in following columns

I'm working on a medicine sheet, where I want to highlight the times when a pill is added to one of the following columns. Right now it looks like this: Each pill works for (about) 7 hours, so I take ...
0
votes
1answer
59 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
2answers
1k 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 ...
1
vote
2answers
128 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/...
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/...
-1
votes
1answer
33 views

How can I conditionally format this Google Sheet with multiple IFTHEN

I'm collaborating on a Google Sheet with approximately 500 rows. I think potentially could use IF, ISBLANK and conditional formatting but I can't conceptualize a formula for this and I've tried ...
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?
0
votes
2answers
29 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....
0
votes
2answers
53 views

Conditional Formatting 'Blocks' of cells

I am wondering if it's possible to use a custom formula in conditional formatting to highlight a single 3x3 block of cells - rather than a single cell, an entire row/column, or the entire range - ...
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 ...
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 ...
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
2 3 4 5
9