# Questions tagged [conditional-formatting]

Spreadsheet feature that allows automatically adding color, text styles, etc. to certain cells or ranges of cells based on the data workbook

852
questions

0
votes

0
answers

42
views

### How to highlight cells based on my defined pattern

Experts, Please help this excel newbie
Admin Developer Subscribe
Contributor Product Owner Write
Viewer Stakeholder Create
Test engineer View
Viewer ...

0
votes

0
answers

8
views

### Why isn't xlPasteFormat carrying conditional formatting to new workbook?

I"m trying to take a workbook with formulas for calculation and export it to a workbook that is value only. The use case is a scorecard for different items, so having the overall scores color ...

0
votes

1
answer

56
views

### I can format the BitLocker encrypted without unlocking it. But I saw lots of articles on internet which say I can't do it?

I can format the BitLocker encrypted drive without unlocking it. But I saw lots of articles on internet which say I can't do it. Is there any damage to my drive if I format it on locked state? Looking ...

0
votes

0
answers

6
views

### Changing cell alignment based on font color

I have a data validation list in D12:D2000 with Income, Expenses, and Savings. In F12:F2000 I enter my amounts. Font color in column F changes according to Col D. Example: Income font F12 changes to ...

0
votes

2
answers

61
views

### Conditional formatting based off multiple criteria

I'm trying to highlight a cell in column K if it meets all of the following criteria:
-if the cell above it is a date that is older than a year
-if the cell in column K is blank
-if the cell in column ...

0
votes

1
answer

42
views

### In Excel, is it possible to copy just the cell color from conditional formatting from one tab to another?

I am working with golf scores. On my first tab, I have the score card which includes the hole numbers, par for the hole and each player's score for each hole. Down below, I have created another score ...

0
votes

1
answer

22
views

### Excel formulae to use conditional formatting each cell in a column which is < or > than the 4th column to the right of that cell

I have a spreadsheet where each cell in each column is compared to the value on the same row in the 4th column from the right and should the value be greater or smaller the font colour is changed ...

0
votes

3
answers

110
views

### Microsoft Excel: Highlight decimal higher than .00

I am trying to highlight a cell based on the point decimal value. I understand how to highlight the point decimal with a MOD function but exclude a full value.
The data is quite simply based on ...

0
votes

1
answer

44
views

### Excel conditional formatting not applied to all cells as configured in "applies to"

The following (link to a) screenshot shows that I have applied conditional formatting to cells O5 through P8 based on the value in column M (of their corresponding row)...
It can be seen that the ...

0
votes

1
answer

36
views

### Conditional Formatting starting and ending based upon cell values in a range

In a given range of x by y cells, I'm looking for a formula that will format cells in a row starting every time a cell value is "x" and ending every time a cell value anywhere in the range ...

0
votes

1
answer

38
views

### Excel Conditional Formatting Cells in a row

I have an excel spreadsheet organizing material orders, I have 2 columns "Date Expected" and "Date Delivered" I have 1 row functioning the way that I want it to which is if "...

2
votes

1
answer

38
views

### Can I make a conditional design based on other cells (Excel)?

I'm trying to make this by Excel rules:
That any cell (in column B) that is near (beside) "1" (in A) will be red, and any cell near (beside) "2" will be green.
Is there a possible ...

0
votes

1
answer

28
views

### How to use conditional formatting based on a different column?

Looking to format a column background color using conditional formatting based on the integer value from a different column. Where or how is the second column referenced?
Bing AI, copilot, says:
...

1
vote

1
answer

45
views

### Layering Conditional Formatting Based on Another Cell Value

I already have a conditional format for a heat scale for each separate row. I want to layer that by highlighting the cell if its corresponding cell on another sheet is above $5,000.
The sheet I have ...

1
vote

2
answers

62
views

### Excel Conditional Formatting, alternating groups of three columns

In columns A, B, and C, I have the original data. In columns J, K, and L, the conditional formatting gives us Green for a match and Red for a mismatch. I'd like to apply that same formatting to ...

0
votes

0
answers

28
views

### Need to make a row a specific color if it contains a specific text

17600 7724 T1 Clematis Complex 0725602889 20 Green Ave R782.00 EFT -R782.00
17612 7527 T2 Duan De beer 0793008797 3 Dromedaris R480.00 EFT -R480.00
17613 Bukes 15 ...

0
votes

0
answers

37
views

### How can I apply conditional formatting to rows that get added to a pivot table when new data is added? Specifically on MacOS

The question is simple, and has been solved in multiple posts such as this one for PCs. Unfortunately on a Mac, that setting does not appear when editing the conditional formatting. This is how it ...

0
votes

0
answers

59
views

### Conditional formatting with formula

I am looking at using a formula based conditional formatting but can't seem to get it to work.
What I am after is:
Its a roster, with variables in it
IF A2 Contains say 0:00 or 0:30 or 13:30 and so ...

0
votes

1
answer

160
views

### IF formula for conditional formatting

I am looking at using IF on conditional formatting but can't seem to get it to work.
What I am after is:
IF C7 Contains any text, then input conditional formatting.
IF cell has no text and is blank ...

0
votes

1
answer

75
views

### Microsoft Excel Conditionally Formatting Multiple Columns based on Adjacent Cell Text

Hello all, I have a question about how to apply a conditional format (cell color) based on (partial) text in the adjacent column. In the screenshot, you will see Column E has a list of zones. Listed ...

1
vote

1
answer

88
views

### How to make excel clipboard copy formatting for more than 250 cells

When copying more than 250 cells and pasting via the excel clipboard, the formatting (like fill colour) doesn't carry over, but on the first ever use of the clipboard, formatting was copy-pasted ...

0
votes

1
answer

47
views

### How to use conditional formatting on a specific formula added?

I want to add a conditional formatting to a cell. In that cell I have a formula that provides 2 dates. The dates in the cell look like this 01/12/2024 and 01/24/2024.
Originally when I had 1 date in ...

0
votes

1
answer

46
views

### IF AND FORMULA using conditional formatting?

Im not sure if the IF and AND formula would work in this scenario but Im trying to use conditional formatting in 1 cell referencing off two other cells.
So in cell H13 has a certain date 1/14/2024 and ...

0
votes

0
answers

23
views

### How to apply separate conditional formatting rules for different Pivot Table Row Lable sections

I have a pivot table that has two sections, a High Priority and Normal Priority section that needs different sets of conditional formatting rules, due to the High Priority section having higher ...

1
vote

1
answer

24
views

### Conditional formatting comparing numbers and words

I want to apply conditional formatting to cell h26 based on its comparison to cell d26. However, cell a1 can only be filled in with "true" or "false" while cell b1 can only be ...

1
vote

1
answer

59
views

### Excel conditional formatting highlighting different cells in range

I need to setup conditional formatting to highlight any cells in the range that are not equal to the first cell. I have attached 2 pictures the first is how the data is typically entered and I have ...

1
vote

1
answer

73
views

### How to clone conditional formatting to another column?

I want to highlight values that are in the bottom 5th percentile in each column, for about 60 columns. I set this conditional formatting for the first column, but I see no way to apply this to every ...

1
vote

1
answer

147
views

### Format to highlight cell in Column D if value less than Column C

new here and sorry if this has been answered. I have searched for the formula but can't get it to work for me.
I have a tracking sheet that I want to have a cell in column D "red, and bold font&...

1
vote

1
answer

68
views

### Coloring cells across multiple excel sheets in an xls file based on a condition

I am new to excel. I have an xls file with 10 sheets. In each sheet I have two tables of size 10 x 10, one starting at position A4 and the other starting at N4. All the entries are numbers.
(Note that ...

1
vote

1
answer

165
views

### Excel conditional formatting with two NOT functions - NOT Match and NOT Blank

I essentially need help making a formula that highlights a cell when the cell isn't blank, and there aren't any matches in two specific columns. My current formula that isn't working is: =IF(AND(NOT(...

1
vote

1
answer

768
views

### How to remove values in conditional formatting

I have conditional formatting rules applied to a workbook. When a user selects No in Row 1 for example, Row 2 and subsequent rows get greyed out. When user selects Yes in Row 1, Row 2 and subsequent ...

2
votes

1
answer

50
views

### Separately color all rows for unique clients listed in one column

I am a relative Excel noob, and to that end, forget about Excel macros. I'm here because this seems to be where the GOATs congregate, and I really need some help.
I have an enormous data set that ...

1
vote

1
answer

221
views

### Conditional formatting not formatting dates

The conditional formatting is not picking up all dates. The rule should be any which are less than today should be orange.
Any help appreciated
Rule's Formula : =F3<TODAY()
Applied to a whole ...

1
vote

1
answer

637
views

### Cell references for Conditional Formatting in LibreOffice Calc using the "Formula is" condition

In Libreoffice Calc 7.6, I want to have cells that do not contain a number to have a certain style ("error"). If the value has a comma instead of a point as the decimal separator: 1.5 vs 1,5 ...

0
votes

0
answers

56
views

### Using Excel: how can I change to colour of a cell based on whether 3 cells in the same row contain ANY text?

sorry for the novice question. I have a spreadsheet looking for sign off from colleagues after reading a document. I would like cells in column 'O'(sign-off complete) to turn green if there has been ...

0
votes

1
answer

88
views

### Is it possible to turn off certain Excel functions related to conditional formatting and data validations?

I have come across a monstrosity of an Excel, while it does not make any sense in my opinion to have this Excel. Some of my colleagues at this large corporate are extremely fond of using it. ...

0
votes

1
answer

81
views

### How to use conditional formatting to progressively turn green to red as the distance between two dates increases

Cell B3 contains a date, under "Email Delivery Date". Cell C3 Contains a date as well. What is the formula or formulas that i am supposed to use in order to have those cells turn from green ...

0
votes

1
answer

65
views

### Excel - status (online/offline) corresponding to concrete number

I cannot deal with the below tasks, and need your help!
The thing is that I need to use a formula to solve this (not just copy-paste, assuming that the data will be much bigger). Basically, I need to ...

0
votes

3
answers

245
views

### Data validation with 2 conditions

I am looking for a conditional formatting formula that validates two conditions from another sheet.
I have Sheet1 and Sheet2: Sheet2 has daily records of workers such as time in and off, Sheet2 ...

0
votes

1
answer

359
views

### Pivot Tables grand total

The "Grand Total" in my Pivot Table does not reflect a (red) negative amount for a deficit year. All Grand Totals for the 5 years show a positive amount. How do I change the formatting or ...

1
vote

1
answer

357
views

### Reference adjacent cell for 'maximum' value when adding Data Bars using Excel Conditional Formatting

Using Conditional Formatting in Excel, I wish to reference the adjacent cell for a set of cells when setting the maximum value for a data bar.
For example, take the simple table below. What I wish is ...

0
votes

2
answers

132
views

### How do we apply conditional formatting based on cell to the left and above but also account for blanks present in between

I am comparing a range of cells and need their values to be aligned lowest - Highest not just when looking from left to right but also from top to bottom. I have used conditional formatting to compare ...

0
votes

0
answers

119
views

### Outlook conditional formatting for number of attendees

How to colour code one-to-one meetings in the Outlook calendar?
I can't find a field in the conditional formatting list of fields that is "number of attendees".
Ideally the rule should be if ...

0
votes

1
answer

191
views

### Apply conditional formatting on the columns of a pivot table, where the values are shown as a percentage

My data includes the revenue from different products(around 6-7 products) marketed by different salespersons(around 5). I have a pivot table with the product labels in the row and sum of revenue of ...

1
vote

2
answers

90
views

### Conditional Formatting Excel: If cell C3 is closer to ZERO value than cell A3, I want cell F3 to display "Correcting" shaded green

I need a conditional formatting formula that will enter unique text and shade the cell to identify if a "trader" is correcting their borrowing position.
Context: traders borrow and loan &...

-1
votes

2
answers

705
views

### How to copy/paste cells from a conditionally formatted sheet to another file or sheet with formatting but without conditional rules?

I have an excel file "Book1" with conditional formatting enabled on "Sheet1".
Conditional rules are based on a formula.
For example, highlight the entire row blue if the value in ...

0
votes

1
answer

134
views

### Conditional formatting based on cell on different sheet

I have two sets of data (21x14 sets of cells), on different sheets (but in corresponding cells therein).
Conditional formatting within the sheet works (e.g. Cell Value > 0, applies to =$B$5:$N$25, ...

0
votes

1
answer

267
views

### Excel Conditional Formatting - Comparing One Column to Every Other Column

I'm stuck on a problem where I want to compare one column to every other column and highlight matches. In my example here I have three columns with three rows each. I want to compare the column A to ...

0
votes

2
answers

985
views

### Excel VBA Function Not Detecting Cells Colored by Conditional Formatting

I have a few conditional formatting conditions on my excel sheet that fill in cells with different colors. I am trying to count the number of cells colored by my conditional formatting in excel so ...

0
votes

2
answers

201
views

### How do I format a target cell based on a source cell, using VBA?

I'm looking to copy the format of a cell within the table table1 to cells with matching text within the second table table2.
So for instance: NOT(H) is showing as green in table 1 and I want it to ...