Questions tagged [conditional-formatting]

For questions about conditional formatting in spreadsheets.

Filter by
Sorted by
Tagged with
1
vote
1answer
46 views

Isolating conditional formatting to each range in a column

I've set up conditional formatting to highlight the top 3 values (gold, silver, bronze) in a range of rows. However, I want to be able to copy/paste the conditional formatting below the initial rows ...
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
1answer
90 views

How to get conditional formatting in Google Sheets if a cell contains specific formula/function?

I would like to set conditional formatting in my GS for cells that not only are a formula, but have a specific type of formula. I know I can do a conditional formatting to highlight cells that are ...
1
vote
1answer
389 views

Conditional Formatting w/multiple conditions and partial text match

I am working in google sheets and have a manual input quantity in column E. I am trying to write a conditional format that will highlight each cell in column E (or the whole row) that is greater than ...
1
vote
1answer
91 views

How to highlight cell if any of 6 cells to the right not blank

I would like to highlight the value in column D if any of the cells in the same rows from columns E:K are not blank. I have tried this formula in custom formatting: =NOT(ISBLANK($E137:K137)) This ...
1
vote
1answer
2k views

Conditional formatting on merged cells

The situation - I have rows of data where similar names are grouped and merged to show all those rows are for the same individual like so: Now I'd like to have conditional formatting where say if the ...
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
51 views

Conditional Formating if cell contains certain characters

I need to come to a custom formula in Google sheets that highlights a cell in the column if the cell contains certain characters in Cyrillic letter. Some of the Cyrillic characters that look like ...
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
34 views

Formatting based on multiple cells and duplicates

I will try my best to explain the situation : I have a sheet where we enter test data and serial numbers. Column A is serial number Column C is if the unit passed or not. I currently have ...
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
22 views

Highlight data that match with data from other sheet

I have two tabs in a Spreadsheet. Both are having a list of data. I want to highlight cells in one tab that match with cells from another tab. For example: Tab 1 Column 1 ABC XYZ PQR DEF Tab 2 ...
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
44 views

Conditonal Formatting if cell A is within a range of numbers to make cell B a different color

I am looking to create a conditional format that if a cell "A" is within a range of two numbers that cell "B" will then change color in Google Sheets. Please help.
1
vote
1answer
30 views

Entire Column green if all cells in it are empty

I would like all columns that only contain empty cells to light up green. In the below picture these should be: C3:C8, D3:D8, E3:E8, L3:L8 What would be the correct custom formula for this? Bonus ...
1
vote
1answer
3k views

Adding date picker to Google Sheets cells while data validation is customized

I have a column with customized data validation (custom formula) that accepts only dates, provided that a few other conditions are met. How can I add a date picker to the cells of this column? ...
1
vote
1answer
52 views

Dynamic Master sheet that grabs red formatted cells from another sheet

The title may be a little too ambiguous but I'll try to give a rundown as best I can; I have a Google sheet with multiple "Sheets" or Tabs (as I'd like to call them) within it. The Main tab is blank ...
1
vote
1answer
38 views

Google Sheets Conditional Formatting Formula

I am doing a formula in conditional formatting and I need it to be relative to each of the 1500 rows but it keeps retrieving an absolute value. how do I get around putting a new formatting formula for ...
1
vote
1answer
1k views

Google Sheets Conditional Formatting not working for all cells

This is my first question using StackExchange, so please bear with me. I am making a spreadsheet for tracking due dates for training. Sheet 1 shows due dates that people with view only capabilities ...
1
vote
1answer
225 views

Google Sheets conditional formatting for Max value that meets a second condition

I'm working with a baseball statistics spreadsheet in Google Sheets, and I want to highlight the maximum value in my batting average column, but only if that value is for a player who has satisfied ...
1
vote
2answers
52 views

Conditional Highlight: color change cell only if multiple others filled in

I have a shift sign-up sheet in which I would like the cells in column A to be highlighted only once there is a value (name) in the corresponding cells in columns B:D. In this example, I would like ...
1
vote
1answer
34 views

Conditional formatting cells with multiple conditions and relative references over a range

I have a Google spreadsheet with arbitrary data. Three adjacent columns (let's say A, B and C) have been set up with Data Validation to only allow values from 1 to 10. I'm looking for a way to ...
1
vote
1answer
146 views

Formula works in cells but not in conditional formatting

So, I have a Gantt chart style diary. I want to apply conditional formatting to any column whose date (in row 2), is a public holiday. There is a sheet called 'Public Holidays', that has the dates ...
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
1answer
43 views

Automatic cell coloring via conditional formatting

I am working on a sheet for a game I play and having some trouble with cell coloring. I have one sheet, named "PlayerList" which maintains a list of player names, class and role. Players are ...
1
vote
1answer
57 views

Conditional Formatting using Google Sheets

So I'm trying to build out a simple campaign tracker and I've been running into a few issues with the conditional formatting on google sheets. I need the cells on column C to change color and format ...
1
vote
1answer
627 views

Join multiple ranges when using conditional formatting

I have a simple conditional formatting custom formula which highlights duplicate values in a column: =countif(A:A,A1)>1 I have another column on another sheet (same workbook) which I would like ...
1
vote
1answer
56 views

check if cell is empty OR has a value, AND cell in row isn't empty then assess as true or false

I'm trying to format a column so that if the column A cell is NOT empty, AND the column H cell is either empty OR "no" =AND(NOT(ISBLANK($A$1:$A)), (OR(ISBLANK($H$1:$H)), (LOOKUP("no", $H$1:$H))))
1
vote
1answer
38 views

Adapting Conditional Formatting Formula for Cross Sheet Reference

I currently have a sheet setup for work that compares 3 columns of data with conditional formatting. The goal is to identify whether the same string of characters can be found 1 2 or 3 times across ...
1
vote
1answer
83 views

Conditional Formatting Text with more then one value

I am looking to have a row of 20 cells change font colour based on ABC to Z being white. Then 0 to 10 being blue. Then all the symbols being red. Is there a way to do this? I found I can do this but ...
1
vote
2answers
619 views

Date fields that refuse to be parsed/formatted

I have some very mysterious date fields in a huge (600 000 records) CSV file which absolutely refuses to behave. They come up aligned left, and conditional formatting shows that they cannot be seen ...
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
26 views

How do I conditionally highlight cells

Not sure if I'm sharing this right but below is a link to my sheet. Cell C3 is past today so it is red. What I'm trying to do is have it go back to white when I enter the next "Last change" date in ...
1
vote
1answer
104 views

Conditional Google Sheet Checkbox

I am creating a spreadsheet which can track all of the replacement items I am sending out for my business, however, I also want to be able to track my refunds on the same spreadsheet. I have got it so ...
1
vote
1answer
342 views

Conditional Format Copying in Google Sheets

I am looking to copy over a conditional format that changes the colour of an array of cells when checking a checkbox. This works perfectly fine on the first checkbox. However, when I try to replace ...
1
vote
2answers
5k views

Conditional Formatting - Custom Formula - Text Contains

I have dates in column B that include weekdays in the following format: DDD, MMM DD, YYY (For example, Sat, Jan 19, 2019). I want each row to auto format to a specific background colour based on the ...
1
vote
1answer
309 views

Conditional Formatting with Multiple Conditions Weekday and Time

I'm working with Google Sheets and want to highlight cells in long date format (e.g. 11/13/2018 21:00:00) that are Tuesday and 21:00:00. Here is my attempt: =AND((weekday(C4:C124)=3),(EQ(RIGHT(C4:...
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
25 views

Using conditional formatting to highlight entire area instead of just one cell

Here's a screenshot of the situation: When I hover over the rule to the right which I defined, the wanted area is highlighted entirely, so I would presume I entered everything correctly, but only one ...
1
vote
1answer
12k views

Use checkbox to change the background color of a range of cells in Google Sheets

I'm trying to have a checkbox change the background color of a range of cells using conditional formatting custom formula =$N123=True. With the range defined in conditional formatting only the first ...
1
vote
1answer
35 views

Conditional Formatting in GSheets

I have a sheet tracking activity scores for players across multiple accounts in a game I play. I am trying to format the scores so that the monthly cells (Columns I through T) will be red if 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
138 views

Conditional formatting with multiple criteria for one cell

I have 5 cells (A1:E1) that are filled with either 'yes', 'no', or 'maybe'. Can I have conditional formatting on F1, where if 'yes' is green, and if 'no' is red? To clarify: =countif({a1:e1};"yes") ...
1
vote
1answer
56 views

Conditional formatting over wide area of cells, referencing other cells

As data validation does not seem to be able to reference cells for numerical conditions (instead only being able to hardcode numbers); I have fallen back on conditional formatting. However, it does ...
1
vote
1answer
970 views

Formatting cells based on upcoming date in Google sheets

I am trying to format a cell to be highlighted red if the following conditions are true: the future date associated with that row (which is in a separate cell) is less than 21 days from today, and ...

1
3 4
5
6 7
9