Questions tagged [conditional-formatting]

For questions about conditional formatting in spreadsheets.

Filter by
Sorted by
Tagged with
0
votes
2answers
28 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
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 ...
1
vote
1answer
12 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
2answers
52 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 - ...
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
32 views

Google sheets conditional formatting to show selected text

So i've been trying to find a way to do this but struck a wall so hoping someone here might have a idea! Problem: We have a list of signatures that can be choosen with dropdown list in Google sheets. ...
0
votes
0answers
15 views

Conditional Format cell if the value is just text or a reference [duplicate]

How to Conditional Format cell in Spreadsheet based on whether the value is just text or a referenced cell from another tab
0
votes
1answer
19 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
32 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 ...
0
votes
1answer
34 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
19 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
28 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
59 views

Percentile Conditional Formatting in Google Sheets - Copying the formatting but isolating the range

I have setup conditional formatting using a green-red percentile color scale. This works fine until I copy this section down the sheet. When I do this, the numbers in the second section affect the ...
0
votes
1answer
39 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
45 views

Google Sheets - Return a text value based on another cells text value

I have a set group of "program names" in a column, and want to have another column automatically write the matching "acrononym" for its sister value. For example: Master in Finance ...
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 ...
1
vote
2answers
32 views

Transferring an Excel document to G Sheets, how do I fix the slightly broken auto-borders implementation?

I'd like to transfer this Excel spreadsheet to Google Sheets, maintaining the automatic background formatting functionality, particularly in the case of the borders. Here is the same spreadsheet ...
0
votes
1answer
22 views

Google sheets conditional format to highlight a column containing items from another list

I have rows of data, Col. A will be the order number and there will be duplicates of the order number (this is for each individual item purchase and MUST NOT be removed to give unique numbers). Then I ...
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
2answers
132 views

Conditional Formatting for cells that are within 1 hour of the date and time posted within a cell

I have a Auction that I am updating and posting bids to on a Google Sheet that bidders can view. The condition to the auction is that the item will be sold to a bidder if no one has bid on said item ...
0
votes
1answer
29 views

Google sheet currency (changable)

I was usually working on Excel sheets, in which I had option to choose currency (file was used as a template). It was based on Conditional formatting and simple formulas so it worked like charm. So it ...
0
votes
0answers
26 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
20 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
60 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
1answer
28 views

Array formula works in the sheet but invalid in conditional formatting

I have a list of time intervals along with their convenience ratings. I wish to highlight intervals rated anything other than impossible which conflict with those rated impossible. I use start1 and ...
0
votes
1answer
30 views

Applying conditional formatting independently to each other

Here is an example file for where I want to apply conditional formatting independently of each other First I have highlighted all males in the spreadsheet Then if they are a senior I want the text of ...
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 ...
-1
votes
1answer
81 views

How to apply conditional formatting to part of a string in one cell in google sheets [duplicate]

I'm not sure this is possible but thought it was worth the ask: I'm trying to use conditional formatting to change the colour of part of a string contained within a single cell in google sheets. I ...
0
votes
0answers
15 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
29 views

Google Sheets: How to have conditional formatting based on each individual cell?

I have a Google Sheet where it's a table full of people's Euro Cup soccer picks. I want to have a column at the end where I type the winning team into a cell. If that value matches then I want the ...
0
votes
1answer
45 views

Google Sheets conditional formatting multiple columns with ignoring blank cells

I want to highlight the cells in E/F/G columns when they exactly match the score in column D, but I want formatting to ignore blank D cells. Can I do this somehow?
0
votes
1answer
23 views

Minimum value across multiple rows, conditionally formatted

I need help understanding how the MIN formula mixes with conditional formatting, cause I can't wrap my head around it. Here's specific situation: I've successfully got formatting for minimum across ...
0
votes
1answer
55 views

Conditionally Format Non-Blank Cell in Range When Adjacent Cell on Same Row Contains Either or Both of Two Specific Values

Building on a question I asked here, I am trying to conditionally format the non-blank cell within a range when an adjacent cell on the same row contains either or both of two specific values ("...
0
votes
1answer
25 views

Conditional formatting with custom formula: a block of cells

I am trying to highlight all the values in B2:D4 that are greater than the value in B7. Tried with =or(B2>B7,C2>B7, D2>B7) and others, but I could not get what I wanted.
0
votes
1answer
30 views

Conditionally Format Non-Blank Cell in Range When Adjacent Cell on Same Row Contains Particular Value

I am trying to conditionally format the non-blank cell within a range when an adjacent cell on the same row contains a particular alpha value (ach in this instance, regardless whether ACH is written ...
0
votes
2answers
66 views

How can I apply a conditional format in Google Spreadsheets based on multiple factors?

So I'm making this attendance tracker for my school, and I need to apply a different format depending on the value of the cell and if a checkbox is ticked or not. Here is a screenshot of the different ...
0
votes
1answer
52 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
42 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 ...
1
vote
1answer
22 views

Using a custom formula on a sheet that is constantly expanding

A custom formula for 5 possible colors, by day is used to highlight entries by DayOfWeek Is it possible to use a format like A2:A instead of manually editing it as the sheet grows bigger? Formula ...
3
votes
2answers
916 views

How to Apply Conditional Formatting Based on Adjacent Cell Value for Entire Column?

I am looking to apply conditional formatting to all cells in a column (excluding the header) where a colour will be applied depending on if its value is greater, equal, or less than the adjacent cell. ...
0
votes
0answers
7 views

Google Sheets and conditional formatting [duplicate]

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 ...
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 ...
0
votes
0answers
23 views

How to conditionally format the text of a cell using a colour scale in Google Sheets?

I know how to do this easily with the background colour of a cell, but when it comes to the font colour itself there seems to be such no automated method. I have searched throughout this site but ...
0
votes
0answers
15 views

How to conditional-format text of a cell using a colour scale in MS Excel?

I know how to do this conveniently with the background colour of a cell, but when it comes to the font colour itself there seems to be such no automated method. I have searched throughout this site ...
0
votes
2answers
246 views

How to make the cells of query function results with borders that are dynamic according to rows/column numbers?

https://docs.google.com/spreadsheets/d/1VsEvt2KnYGnlN_qHjkjPohVHF5MUqfyHD7tSk0VpkqA/edit?usp=sharing I would like to make the cells that have query results in All_Patients tab with borders instead of ...
1
vote
1answer
34 views

How to automatically fill, sort and conditionally format 1st day of the week according to given year and month

How can I fill-in column A, make it start with the day's name according to the year in A2 and month in A1 and conditionally format them? https://docs.google.com/spreadsheets/d/...

1
2 3 4 5
9