Skip to main content

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

Filter by
Sorted by
Tagged with
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 ...
Srinath's user avatar
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 ...
Patzy's user avatar
  • 1
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 ...
explore-all-techs's user avatar
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 ...
David Stevens's user avatar
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 ...
Chris Shubert's user avatar
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 ...
Dawn W's user avatar
  • 1
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 ...
JacquiJae's user avatar
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 ...
OPL's user avatar
  • 1
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 ...
Mark Calvert's user avatar
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 ...
dgo's user avatar
  • 883
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 "...
Shae's user avatar
  • 3
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 ...
Yoar's user avatar
  • 139
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: ...
Nick's user avatar
  • 5
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 ...
user1902730's user avatar
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 ...
WynnSmith's user avatar
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 ...
Sumi Janse van Rensburg's user avatar
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 ...
Warren Elson's user avatar
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 ...
Anne D's user avatar
  • 3
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 ...
Anne D's user avatar
  • 3
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 ...
Andy's Excel's user avatar
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 ...
Daniel Cho's user avatar
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 ...
Danny Zambrano's user avatar
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 ...
Danny Zambrano's user avatar
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 ...
Adam's user avatar
  • 1
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 ...
user1881394's user avatar
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 ...
Joseph Bowditch's user avatar
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 ...
Edward's user avatar
  • 163
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&...
Danielle Davis's user avatar
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 ...
wanderer's user avatar
  • 113
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(...
Annette's user avatar
  • 11
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 ...
sc222's user avatar
  • 11
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 ...
alm's user avatar
  • 23
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 ...
Choufleur235's user avatar
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 ...
mcnesium's user avatar
  • 551
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 ...
Laura Harvey's user avatar
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. ...
Snowflake's user avatar
  • 181
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 ...
Kaleb Smith's user avatar
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 ...
Andon Key's user avatar
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 ...
Louis Cerato's user avatar
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 ...
Bob Rakow's user avatar
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 ...
David Gard's user avatar
  • 1,505
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 ...
kaushal sharma's user avatar
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 ...
Matei's user avatar
  • 101
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 ...
san's user avatar
  • 3
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 &...
Kelly Marie's user avatar
-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 ...
Veki's user avatar
  • 161
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, ...
TKCZBW's user avatar
  • 23
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 ...
Koreanwest's user avatar
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 ...
Stephen's user avatar
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 ...
Chris98's user avatar

1
2 3 4 5
18