Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [conditional-formatting]

For questions about conditional formatting in spreadsheets.

0
votes
1answer
13 views

Simple Scorecard Conditional Formatting

I simply want to create a scoresheet comparing scores to par. If less than par then a red number, if more than par then highlight red, if equal to par then highlight green. Here is what I'm trying ...
0
votes
2answers
13 views

Format cell if all the cells in a row are not empty

I tried all kind of formula but they all seem to work the other way around for me. I have a very large sheet with lots of columns. I'd like to have the first cell in the row to be a certain color if ...
2
votes
1answer
10 views

Format cell, If word from list in cell

I'm trying to color tag cells according to keywords they may contain. I've searched just about everywhere, and have tried various applications of the Search and Find functions to no avail. Imagine I ...
1
vote
1answer
13 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
1answer
10 views

How can I conditionally format cells to denote past/future/current dates?

I have a church rota Google Sheet. Column A shows the date of each service. To make it more obvious at a glance, I would like cells in column A to apply formatting so that dates in the past are ...
1
vote
1answer
7 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 ...
0
votes
1answer
12 views

Google Sheets Conditional Formatting for expiration dates

I need help! I need to create conditional formatting for expiration dates: Cells should stay green Cells should turn yellow when 1 month of exp. date Cells should turn red once expired
0
votes
2answers
9 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 confirm if they are ...
1
vote
2answers
14 views

Change cell colour based on another cell containing text (day name)

I am new to Google Sheets and trying to create a custom formula in conditional formatting to make the fill colour of a cell change based on another cell containing a specific text. I want to change ...
1
vote
1answer
24 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
2answers
9 views

How do I detect duplicates in two worksheets?

I have 1 Google Sheet with 2 worksheets: Worksheet "1" has 1 column A with 5 lines of data (AAA, AAB, AAC, AAD, AAE) Worksheet "2" has 1 column A with 5 lines of data (AAA, BBB, CCC, DDD, EEE) I ...
1
vote
1answer
18 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 ...
0
votes
1answer
37 views

Google Sheets Conditional Formatting Isn't Working

I am making a spreadsheet in Google Sheets and my conditional formatting works in some cells and not in others. I have gone so far as to delete all of the formattings for the entire workbook and ...
1
vote
1answer
10 views

Conditional Formatting Duplicate Invoices in Google Sheets

My workplace uses Google Sheets to track invoices across all locations. The two most important columns are next to each other and titled Invoice number and Vendor. I wanted to highlight the Invoice ...
0
votes
1answer
16 views

Max value conditional formatting rule not working in Google Sheets

I want the max value in Column B to show up. I put in this formula but it's not working. What am I doing wrong? Here is the table
1
vote
1answer
35 views

Can conditional formatting reference other sheet?

I needed to check which indexes exist on another sheet. So for the A:A range, I made conditional formatting with the following formula: =COUNTIF('Other Sheet'!A:A;A1) That had a red error outline. ...
0
votes
1answer
35 views

Cell with multiple color formatting results only to first color being applied

If a Google Sheet cell has 2 Conditional formattings, one which changes only font color, one which changes only the background, only the first conditional formatting affects the cell. The reason ...
1
vote
1answer
12 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))))
0
votes
1answer
5 views

Flagging empty cells if date in another cell has passed

Good afternoon! I've created a test sheet to help visualize this - https://docs.google.com/spreadsheets/d/1-qHH4GfeIZz-7OBHFpp4trrFNg7l-gBHDT2MHg9tFmE/edit?usp=sharing I'm aiming to have cells ...
0
votes
1answer
11 views

Quick way to make an automatically color-coded Google sheet for every day of the year?

So if the day is January 1st, the cell will be one color. If it's January 2nd, it'll be another color, and so on for every day of the year. Is this possible?
1
vote
1answer
22 views

Conditionally format rows with partial matches

I have a Google Sheets table that looks like this: (col a) (col b) (col c) (col d) Company Cohort Session Count Group -------------------------------------------- Acme ...
1
vote
1answer
16 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
19 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
1answer
35 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
1answer
18 views

Combine Custom Formula with Colour Scale in Conditional Formatting

In Conditional Formatting in Google Sheets, I'm wondering if it is possible to combine the Format Cells if - Custom Formula is with a Colour Scale? It would appear not, but is there a clever ...
0
votes
2answers
22 views

How to apply conditional formatting only if cell has X value? [google sheet] [duplicate]

I have a sheet with statistical data to which I had applied color scale conditional formatting. Some rows I set to have green for highest and red for lowest number in row and other rows the other way ...
1
vote
2answers
28 views

Conditional formatting rule that compares against a range of values

I have a list of 2019 dates (col A) and holiday dates (col G). Wherever there's a date in col A that matches any date in the range G2:G20, I would like to highlight it in grey. See this sample ...
1
vote
1answer
16 views

How to color cells in column A if cells in other columns relating to those column A cells are filled in?

Column A contains student names. The other columns show work that is missing or incomplete. I'd like to be able to have cells in column A colored in if work from various classes is missing, without ...
1
vote
2answers
30 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
23 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
18 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
13 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 ...
0
votes
4answers
44 views

Show a Running Target Based on Today

I'm creating a running target from a quarterly Total divided by known trading days Current formula in I4 is =IF(H3<>"",I3+O$30,"") H3 = Yesterday's Sales Numbers I3 = Yesterdays Running Target ...
0
votes
2answers
40 views

Conditional formatting by using the note in Google Sheets

How can I use conditional formatting by using the note on a specific or many cells in Google Sheets? For example, I would like to set up conditional formatting to a specific cell and when I use a note ...
1
vote
1answer
24 views

Conditional formating if cell is a formula

I'm trying to have cells which value has been entered manually and cells that are the result of a formula differently, is there a way to do that?
0
votes
1answer
113 views

Can I use conditional formatting to highlight a cell for dates less than 30 days away?

I have a large spreadsheet where I need to keep track of coming expiration dates and I would like dates which are within 30 days from today's date OR which have already passed to be highlighted in red....
1
vote
2answers
337 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 ...
0
votes
0answers
32 views

Conditional formatting weekly, fortnightly totals for my budget spreadsheet

I am making a budget spreadsheet. I would like to enter certain expenses periods, i.e. weekly, fortnightly, monthly, quarterly and yearly. I would also like a column showing total monthly and yearly ...
0
votes
1answer
217 views

Conditional formatting with color scale for many rows independently once

I create reports with different cohort tables. Each row of a table must have conditional formatting with color scale (depending only on current row values, i.e. regardless of other rows min/max values)...
0
votes
1answer
27 views

Google Sheets Conditional Formatting Multiple Cells with Different Colors

I am studying for a big exam and want to set priorities using conditional formatting. For example if C90, C91, C92 are blank than the color would be white; if C90, C91 are blank but C92 is not blank ...
0
votes
0answers
40 views

How to use Sheet, Range protection and Conditional formatting simultaneously in Google Sheets?

I have created a google sheet for my sales team having two members. Gave access to them for two columns (Followup Date and Status) to fill their daily report. I have created another column '...
1
vote
1answer
127 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:...
0
votes
0answers
15 views

How to highlight a cell in column A if the text in column B matches text in a list on another tab?

I have a Google Sheet set up with place names in column B as below. I have another tab on the same spreadsheet with a list that can change from time to time depending on which stores needs items ...
0
votes
2answers
58 views

Conditional formatting if entry is final entry of the day

I have a Google Sheet in which I keep track of transactions, kinda like this: | Date | Funds | Running total | |---------|---------|---------------| | 5/23/18 | 10.00 | 10.00 | | 5/23/...
0
votes
1answer
1k views

Google Sheets conditional formatting for multiple columns

I'd like to set up conditional formatting in columns B:D such that blank cells in B:D are highlighted but only when the same row in A is NOT empty. I think the custom formula should be something ...
1
vote
1answer
46 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
371 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
451 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
1answer
27 views

Dependant Multi Conditional Formatting

So I am building a spreadsheet and everything was working fine but then I kept tinkering with it and making it more intuitive (and less work on the user) and ran into a snag. What I am trying to do ...
1
vote
1answer
20 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 ...