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 ...
