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
15 views

Possible to implement more code, so that highligted dates does'nt show until "in progress" is written

I am coordinating a large amount of production orders that are linked to thereown projects. In the worksheet that I am working on I have created a calendar which I have managed to highlight weekend ...
user avatar
  • 33
0 votes
2 answers
16 views

EXCEL conditional formatting

I have a worksheet where I am attempting to have a row highlight if a specific cell in the same row is not blank. Is there a way to apply that rule to the entire worksheet without formatting each ...
user avatar
0 votes
0 answers
6 views

How to conditional format in Google Sheets based on a external resource [migrated]

I have a Google sheet that has a value of a stock I bought in the past. The page was stark with just white cells and black text. So I decided to brighten it up with some colour. One thing I want to ...
user avatar
0 votes
1 answer
43 views

How to highlight specific dates in an excel calendar based on start and end date?

I am coordinating a large amount of production orders that are linked to thereown projects. In the worksheet that I am working on I have created a calendar which I have managed to highlight weekend ...
user avatar
  • 33
0 votes
0 answers
36 views

How to highlight cells in a row based on start date and end date in a calender in excel 2022

I am working on a worksheet that is used to overlook several projects and related orders. I need to be able to highlight each cell in each row that correspondes with that order and calendar row based ...
user avatar
  • 1
0 votes
0 answers
5 views

How to color cells based on other cells' colors?

I use color scales on each row's three month-over-month growths. How to make aother table for each date that show the name (PP, PE, PVC) in colors that are same as ther month-over-month growths (an ...
user avatar
0 votes
0 answers
25 views

Fade out Excel cells with errors without using conditional formatting

Is there a way to fade out cells that have errors that doesn't require using conditional formatting? I have been unable to fix an issue that causes hundreds to thousands of duplicated rules (see this ...
user avatar
1 vote
0 answers
48 views

Why are my Excel formulas not working as expected? [closed]

These are practice questions from a textbook. I'm trying to solve these questions using MS Excel. Attached are screenshots of the questions with examples I have tried below: For total revenue, I used ...
user avatar
0 votes
0 answers
30 views

Conditional formating of groups in excel

My goal is to flag (via conditional formatting) any cell with the same 'code' but different 'prices' with in the same 'column'. I have added a screenshot of what the final output should be. Is this ...
user avatar
0 votes
1 answer
18 views

Excel conditional formatting of groupings with a variable number of rows

I have a vehicle electronics inventory with a multiple and variable number of rows per vehicle representing devices installed in that vehicle that I would like to format with alternating colors per ...
user avatar
  • 1
0 votes
1 answer
25 views

Conditional formatting based on selection from a dropdown list

I have a spreadsheet that is used as a sort of a schedule. Each person has their own ID number and the ID number is shown in a distinct cell. So if my ID is 41, I might see myself scheduled 9-12 on ...
user avatar
  • 3
1 vote
1 answer
26 views

How to highlight a cell only if it contains the minimum value in a row?

I am compiling a price comparison between a brands products in different online shops, of which one should have a benchmark fuction. So I have my item numbers in the first column of the spreadsheet, ...
user avatar
  • 11
0 votes
1 answer
16 views

Permanent Formatting - TRUE or FALSE

Is it possible to permanently apply conditional formatting/custom format on all spreadsheets including the new I open. If the cell value is TRUE, highlight in Green If the cell value is FALSE, ...
user avatar
1 vote
1 answer
51 views

Why does MS Excel change my conditional formatting rules when run as a macro?

I have some pretty standard conditional formatting rules set up to help monitor my organisations printer toner levels. When the rules are applied "manually" everything works fine and the ...
user avatar
  • 11
0 votes
1 answer
28 views

Highlight entire rows when values in a single column are unique (conditional formatting)

I have a spreadsheet with several columns of data and a couple thousand rows. Each row contains a product and each column contains details about that product. Example: Row # Category ID Item Item ...
user avatar
1 vote
1 answer
38 views

How to highlight cells in Excel that end in a numeric value

I work at a library and I'm given a report to create an Outdated Stock Report/Shelf Lists that rely on an item's Publication Date. Unfortunately, because of the nature of serial publications, the ...
user avatar
  • 33
0 votes
2 answers
39 views

Highlight cell with different text than in cell to left

I have a table containing text. I'd like to use conditional formatting to highlight, in each row, those cells which differ from the cell immediately to the left. I'd like to apply this to a particular ...
user avatar
0 votes
1 answer
41 views

How to conditionally format if not on list?

Every tip online about conditional formatting and a list is about highlighting cells that match on the list. How can I highlight cells that don't match (ignoring blank cells). For example, a list of ...
user avatar
  • 5
0 votes
1 answer
48 views

In a pivot table, how to apply conditional formatting by label instead of by group

In a pivot table you can apply a conditional formatting to a group of value rather than to a cell or to the whole field thank to the "Applies to" option of the "Edit rule" window. ...
user avatar
0 votes
1 answer
63 views

Able to conditional format Outlook 2013 calendar where Required Attendee's email domain is anything other than MYCOMPANY.COM?

I'd like to create a rule that assigns a color to any calendar invite that has any external participant, such as perhaps looking at the domain and seeing their domain is different from my own?
user avatar
  • 223
0 votes
3 answers
55 views

Why is my conditional formatting not working?

I have a column of consecutive dates. I would like to highlight the rows for Saturdays. I have Conditional Formatting applied to $2:$112, and the formula for formatting is =weekday($a2) = 7. However, ...
user avatar
0 votes
1 answer
24 views

How to check for a value of ** in IF() in MS Excel?

I have an Excel worksheet and I'm trying to use a formula to conditionally set the value of one column based on the value of another column. I have two columns: Original text (text) Processed text (...
user avatar
0 votes
1 answer
54 views

How can I write a formula to conditional format cells that contain two ampersands anywhere within the cell?

I have a long list of names, most of which contain an ampersand (&). Some contain two ampersands at various places within the cell. I need to conditionally format the cells (just highlight them) ...
user avatar
  • 1
0 votes
1 answer
29 views

How to conditionally format a cell based on time?

I'm making a sheet and trying to highlight cells based on time but not sure how to do that. so the time in sheet represents number of transactions we have per hour, so I want the sheet dynamically ...
user avatar
0 votes
1 answer
23 views

How to setup conditional highlight between two cells:

Looking to understand how to highlight one cell in one column based on what a cell in a neighbor column says. Column H, in my spreadsheet, displays a differing number of required hours to graduate and ...
user avatar
  • 1
0 votes
0 answers
30 views

Excel table in Powerpoint retaining quality

I have created a table in excel with 16 rows, and 9 columns. A few of the columns contain conditional formatting, including coloured cells, and even data bars. When I take the table over to Powerpoint ...
user avatar
0 votes
1 answer
35 views

Conditional Format to highlight every other row on a sheet that adapts when filtered

Right now, I have a sheet where I've applied a conditional format formula to my sheet which colors every other row in my range. =AND(ISODD(ROW($C3)),ISBLANK($C3)=FALSE) However, I often have to filter ...
user avatar
  • 109
0 votes
1 answer
55 views

Excel: Conditional formatting in ROWS section of pivot table based on result in Values field

I am trying add conditional formatting to the Rows section of a pivot table based on the results found in the values section of the pivot. I have already set the conditional formatting in the values ...
user avatar
  • 3
0 votes
1 answer
84 views

Change Color Based on Color Value Defined in Cell

I want to use conditional formatting to change the color of cell B1 to the color I have defined in cell A1 (using hex values or anything else that will work). For example, if I have "#FF0000"...
user avatar
  • 3
0 votes
1 answer
26 views

Using conditional formatting to highlight cells that exceed the criteria below

I'm working on a spreadsheet that lists width of a product in cell A, and height of a product in cell B. I'm trying to apply conditional formatting to highlight these cells if they surpass the limits ...
user avatar
1 vote
1 answer
26 views

Move the last word of each line to be right aligned

I am creating an index for a big legal book. Each section and subsection and clauses are indexed. These are copy pasted from the actual book and then, the page number is added. It is a word file. For ...
user avatar
  • 209
1 vote
1 answer
111 views

LibreOffice Calc: Use different max value for color scale conditional formatting in each row

I have a dataset like the following (only much larger): Each row represents a task with a maximum number of points available in column B. Every column starting at C represents a Person with their ...
user avatar
0 votes
1 answer
48 views

Overriding a conditional format with another if condition holds

Currently my data are percentages, and it has a conditional format that just formats it using data bars: I would like the sheet to omit all percentages if the value in column I is less than 150, so ...
user avatar
0 votes
0 answers
36 views

Excel Table: Conditional formatting based on comparison of two columns

How can I set the format of one column based on a comparison of two columns? For example, consider the table named "T" below. Suppose I want to set the format of column B. Using formula-...
user avatar
  • 151
1 vote
1 answer
450 views

Formulas - Conditional Formatting

I need the cells from Aug to Dec to be formatted automatically based on the "plan numbers" if actual numbers are higher (green); if lower (red)- I'm trying to set it up so when data comes (...
user avatar
  • 15
0 votes
1 answer
35 views

Conditional formatting relative to neighbouring cell?

Is there a simple way (no VBA) way to achieve a conditional formatting based on a neighbouring cell for two adjacent columns? In above example the left table shows the intended result. If number is ...
user avatar
  • 1,141
0 votes
1 answer
82 views

Excel Conditional Fromatting: I can't keep it to "$A:$A" range, how is this? [duplicate]

I set a rule range to =$A:$A but when I add or update rows the range gets a mess: the rule gets duplicated to single cells and those cells are "removed" from the main rule, so I get ...
user avatar
1 vote
2 answers
41 views

Excel: Display empty date cells as "Never"

I have a spreadsheet with a column named Last Login, and want to display "Never" for all empty cells. I am trying to use conditional formatting for this, and feel like I am SO close to ...
user avatar
0 votes
1 answer
93 views

Conditional formatting based on the difference between two cells

I have % Budget Remaining in Column G and % Program Period Remaining in Column H. Sometimes column G is the larger number, and sometimes column H is the larger number. I want to color code it based ...
user avatar
  • 1
0 votes
1 answer
51 views

Conditional formatting when max work hours is reached based on a formulated cell

Is it possible to do a conditional formatting on column M (Total worked hours) when total work hours >40 hours per work week (Monday-Sunday) based on the employee's position REGULAR EMPLOYEE (cell ...
user avatar
0 votes
1 answer
50 views

excel 2013 conditional formatting is forcing absolute

I am trying to use relative cell expression but when I do it automatically makes it absolute no matter what I try. before apply When I hit apply it changes the value to =$A$5 after apply
user avatar
1 vote
1 answer
312 views

Highlight cells that contains words only from a list

actually, I already have the formula for it, but it's not quite right. so the formula that I have right now is this: it could highlight values that contains "ba" and "ap", so &...
user avatar
0 votes
1 answer
83 views

Highlight a value that contains multiple values in that single cell

I'm trying to highlight cells that has multiple values, so the formula that i have right now is this: https://i.imgur.com/sf2rOQU.jpg it will highlight value that contain orange or blackcurrant. the ...
user avatar
0 votes
0 answers
24 views

how to compare 2 columns and if the value in A is higher than B, copy the value of A over B

I'm trying to compare 2 columns of similar data and would appriciate some help. i need to know how to do the following. I what to know how to compare the values in column A with column B, then if the ...
user avatar
  • 1
0 votes
0 answers
17 views

Conditional formatting when column headers match

This seems pretty basic, but I've searched for hours and hours with no answer... I have two tables on seperate tabs/worksheets. Using conditional formatting, I'm trying to highlight matching data only ...
user avatar
0 votes
1 answer
171 views

Excel: Conditional Formatting - Two rules for one cell

I currently have conditional formatting set up to highlight a cell (E3) red when a payment is made after the due date. However, I have a "late fee paid" column. I want to add a rule where if ...
user avatar
0 votes
1 answer
26 views

Conditional formatting based on a rule

I am building a guest list for my wedding. I have 13 columns and 94 rows currently. I am looking for a conditional formatting formula to highlight the entire row if the cell in column I is blank. I ...
user avatar
0 votes
0 answers
24 views

Conditional formatting of specific records in a series on a stacked bar chart

I'd like to conditionally format each of the three series in a stacked bar chart differently, dependent on a specific text in one column. Each record needs to be independently formatted, so one ...
user avatar
0 votes
1 answer
83 views

Can you use more than two conditions for conditional formatting in MS Word?

I've got a particular group of mergefields that I'm trying to colour using conditional formatting. Basically, this column with the table is a percentage and I need it coloured red if it's below zero ...
user avatar
  • 3
0 votes
3 answers
224 views

MS Excel conditional formatting by date formula does not work

I need to apply conditional formatting on cells containing dates (expiration dates of certificates). I want expired certificates in red, expiring withing a week orange, expiring within a month (30 ...
user avatar

1
2 3 4 5
15