Questions tagged [conditional-formatting]

For questions about conditional formatting in spreadsheets.

85 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
5answers
11k 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
512 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
296 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
31 views

How to elevate a conditional format rule to be the number one rule instantly

I would like to make a newly created rule for conditional formatting the top rule so it has precedent over all others but be able to do so without having to drag it to the top as this takes for ever ...
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
0answers
24 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
36 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
11 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
82 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
17 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
75 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
1k 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
322 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
2k views

Google Sheets Conditional Formatting only applying formatting to certain cells

I am currently working on making a spreadsheet that will figure out which class I should be in based on times. That all works and outputs if I should be in the class to a TRUE/FALSE cell. My ...
1
vote
1answer
101 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
51 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
1k 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
338 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
996 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
593 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
19 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
11 views

Conditional Formatting based on a cell that's only visible in a drop down menu

In Google Sheets, I'm trying to figure out how I can conditionally format a cell within a drop down menu that's based on that same cell from a different drop down option. For example, I have a drop ...
0
votes
1answer
25 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
13 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
32 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
27 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
21 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
14 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
41 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
12 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
14 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
40 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
30 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 ...
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
13 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
0answers
18 views

Conditional Formatting in Google Sheet

On Google Sheets, what formula do I use if there is something in the cell of range F and the corresponding cell in range G is empty to that list "No Content" in the corresponding cell in ...
0
votes
1answer
28 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 ...
0
votes
1answer
53 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 ...
0
votes
0answers
11 views

How do I highlight a cell based on time?

For example, I want to have a cell highlighted while an employee is on break. So for this I have an "OUT" time and an "IN" time. If the employee goes on break at 14:22 and is back ...
0
votes
0answers
20 views

Possible to color code text based on JUST the text value and automatically?

I've been wondering about this for years... it would be such a life-changer. Let's say I have a table: Spectrum Bills XYZ Rent ABC Food/Beverage Spectrum Bills is there any way ...
0
votes
1answer
24 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 ...
0
votes
1answer
34 views

I want a custom conditional formatting to fill a color for a cell depending on the number value after the decimal point

I am entering both positive and negative numbers in a column and want a way to identify them without an extra column for example -100.03 or -250.1 or 100.015. in this example I am listing moneyline ...
0
votes
1answer
95 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 ...
0
votes
0answers
33 views

Conditional formatting with multiple conditions (lost between IF or AND, and not empty cells !)

I am trying to combine formulas here, to put color on specific cells (out of a specific range) when they are not empty, and when a checkbox in another cell is checked. Here is what I tried : =AND($D4=...
0
votes
0answers
971 views

Conditional formatting google sheets with true false

I am trying to highlight cell A5-G5 using conditional formatting. The range I am applying is A5:G90 with custom formula =if(H5:H90,TRUE). However it's only highlighting just A1. How can I highlight it ...
0
votes
0answers
79 views

copy color theme from data validation cells

So I'm using data validations alot. for better organization I create tab called setup and I put my list of possible options there let's say I want to categorize my credit card expenses so I'll put a ...