Questions tagged [conditional-formatting]

For questions about conditional formatting in spreadsheets.

Filter by
Sorted by
Tagged with
0
votes
1answer
6 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
16 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
13 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
16 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
26 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
31 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
24 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
14 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
196 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
6 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
24 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
22 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
11 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
78 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
23 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/...
0
votes
1answer
23 views

Conditional Formatting only seeming to apply if the 'Less than' criteria is selected

I am trying to apply some conditional formatting to a cell on Google Sheets. I want the cell to change green if it is larger than another cell, red if it is less, and yellow if it is the same. However,...
0
votes
0answers
17 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 ...
1
vote
0answers
21 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
64 views

How to combine these formulas in one conditional formatting rule

I am checking if column S is empty & Column Q="Consultation" then I need to set a rule in a cell to make conditional formatting in cell A1. So these are my steps: Step 1: in X column: =...
1
vote
1answer
28 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 ...
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
20 views

Formatting Cells in Google Sheets

I am trying to format cells in a google sheet based on columns before it in the row. For example, I have check boxes in B1 and C1, if both of them are unchecked (false) I would like D1 to turn red; ...
0
votes
1answer
32 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
1answer
43 views

Google Sheets. How to combine a checkbox and conditional formatting?

Here's my problem. I have a cell with a checkbox. I can make it turn green when I check it. But I want it to turn green if no conditions are met and turn orange when a condition is met. The condition ...
0
votes
0answers
18 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
18 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 ...
3
votes
3answers
86 views

Find or conditional format a column of phone numbers NOT in desired format

I have a column of phone numbers in that are in different formats. I want them all to be in this format 0000 000 000. What I do now is manually edit each wrong number into the correct format. How can ...
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 ...
2
votes
1answer
27 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 ...
0
votes
1answer
62 views

Conditional Formatting / Filter out all of past week's rows in Google Sheets

I have a running calendar in Sheets and I want last week's rows to disappear all at once every Monday (Sunday night at 11:59 ideally). I've been trying to use conditional formatting to highlight all ...
0
votes
2answers
49 views

How do I set conditional formatting based on matching from a list on another sheet in Sheets?

First, I have searched repeatedly for this, but I think the biggest problem is that I cannot figure out how to phrase the question properly. This is a huge post; trying to fit all of this into simple ...
0
votes
1answer
75 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
1answer
19 views

Top 2 Values in each Row Conditional Formatting

I have a google sheet with 1006 rows which I am trying to use conditional formatting to identify the two top values across 7 columns (J to P) for each row. I managed to get 1 row to work (highlighted ...
0
votes
1answer
37 views

Strikethrough name in cell in specific range if it contains/matches name from another cell range on same sheet

So we've got a calendar on google sheets, it has a bunch of different things besides just the days but the part I'm working on is easily displaying who is not going to be working that day. We have a ...
2
votes
1answer
660 views

Conditional Format if cell contains partial match for text

I want to conditional format the columns B to G, if one of them contains the text in say, cell H5. This is the formula I use for that, =$H$5=B1 at the moment. What I want is for the conditional format ...
0
votes
0answers
32 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
1answer
26 views

Conditional Formatting Based on another Cell with Multiple IF's

I had a Conditional Format in Place, but it somehow stopped working once I filled in an IF Argument into my cell. A1 Contains a Number I put in manually A2 Contains another Number I put in manually A3 ...
0
votes
1answer
25 views

Can you define a conditional format range without an absolute reference?

I would like to conditionally format a column in my sheet, regardless of how long the sheet is. This is because new rows are routinely inserted, and the sheet gets longer but the conditional ...
0
votes
0answers
588 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
52 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 ...
0
votes
1answer
27 views

Filter cells based on multiple data in 2 columns

Hi, I need to create a conditional filter where at least 3 of the numbers in either cell is greater than 60. I have highlighted the rows in bold that qualify. The first one (lets call them a1 and b1 ) ...
0
votes
1answer
43 views

Conditional formatting with custom formula

I have pretty much zero experience with spreadsheets but I've got what I think is a simple task. I've been keep a log of how I spend my time. I've codified the language so I can easily grab the ...
0
votes
0answers
37 views

How to write a conditioning rule referencing another cell in Google sheets?

Problem: I want the color of the cell to change based on the value of another cell. I have a cell (B1) with MTD capture that is calculated by taking asset A and dividing it by Asset B in different ...
0
votes
0answers
29 views

Conditional Formatting Clear if another cell is not empty

I've tried searching but nothing that is specific for this. I am fairly novice with Google Sheets and can't share the whole thing due to potentially confidential nature of the information. The purpose ...
0
votes
1answer
2k views

Google Sheets - Highlighting Cells if they contain text from another range of cells

I want to highlight a cell in a column with a specific color if it contains any of the elements from a range of cells on another sheet. I believe I need to use 'custom formula is' with the INDIRECT ...
0
votes
0answers
19 views

How to apply CF to rows where there is a duplicate/multiple word in a specific column, AND use a unique color for each different duplicate

I want to have Conditional Formatting apply a color to rows when a word shows up in one particular column, but only when there is more than once instance of that word in the column. So for example if ...
1
vote
1answer
40 views

How to conditionally format italics without changing other parameters?

I am using conditional formatting to color lines based on a priority value in column A, this works fine. I would like to add another rule that would italicize the lines that match a specific parameter,...
0
votes
1answer
26 views

Conditional Format IF Blank by 1st of Month

I am trying to create a Google sheet to track payments for a team. I want a cell to turn red if a value hasn't been entered by the 1st of the month. I have 2 other formats already set up to change to ...

1
2 3 4 5
8