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
798
questions
-2
votes
0
answers
21
views
Highlight the cells used in formula [duplicate]
Excel...If i countif (A1:A10;2) the result appear in another cell c3 example 4.
Iwant when click c3 all (2) in range highlight
https://docs.google.com/spreadsheets/d/1CU6sk_Z03vKT1KALTUWlgLf6KtqZVc_Z/...
0
votes
2
answers
37
views
How to highlight all cells that has been sum up
Imagine I have 4 cells A1, A2, A3, A4
I summed A1 to A3 in cell A4
Is there any formula or conditional formatting that will help highlight Cell A1 to Cell A3 by selecting Cell A4 without clicking on ...
2
votes
1
answer
41
views
Microsoft Outlook Calendar conditional formatting
In outlook calendar, view settings, conditional settings,
Is there a way to change the color of meetings I created but did not send out yet?
- 21
0
votes
1
answer
32
views
Why is conditional formatting in an .xlsm not printing?
I have an xlsm workbook that colours cell backgrounds based on comparison to adjacent worksheets. The adjacency is always 1 to the left, irrespective of whether sheets are inserted or deleted. The ...
- 558
0
votes
2
answers
25
views
number stored as text conditional formatting
I have conditionally formatted a column of serial numbers to color duplicates.
This column is formatted as text.
Problem: when a serial number is added that is not not alpha numeric is is not ...
-3
votes
0
answers
26
views
Libre Office Calc conditional formatting of cells only for cell background colour
There are many questions and answers around about applying a cell style based on some conditions ( Format -> Conditional Formatting ->
Manage... ) but I could not find anything that tells me how ...
- 115
-1
votes
1
answer
32
views
Set conditional formatting for a matching number across a workbook based on the value of a cell in one sheet
I have a list of phone numbers that get randomly assigned to a set number of sales staff. The random list is copied to a sheet titled with their name. When they call a number, they have a status ...
4
votes
1
answer
58
views
How to stop Excel from combining Conditional Formatting rules into 1 broken rule
I understand that Conditional Formatting is a horrendous tool, much like Excel itself, but it's the only realistic option so I'm stuck with using it.
However, I'm unable to grasp how painfully stupid ...
- 194
0
votes
2
answers
97
views
Format number in Excel to align decimals but also remove decimal point optionally based on size of number
I'd like to create a publishable data table in Excel. Numbers may range from 0.010 to 1,000. I need to have similar significant figures and aligned decimal points. This is what I am looking for as ...
0
votes
2
answers
35
views
In Excel, Format a Number with Intermediate Spacing AND Optional Decimal
I have a series of numbers in Excel that I would like formatted in a certain way and I need some help.
Background:
I work in construction, and am using the Construction Specification Institute's (CSI) ...
- 1
0
votes
1
answer
33
views
How can I use conditional formatting to highlight cells that don't reference a cell on another sheet?
I have a workbook that contains two sheets, fruits and images. The images sheet has a Fruit Reference column to specify which Fruit ID on the fruits sheet is shown in the image.
fruits sheet:
images ...
- 175
-2
votes
1
answer
23
views
How to use conditional formatting in excel for a crosstabbed table with multiple conditions?
I am having trouble in excel using conditional formatting for my table. I need to highlight the sample values that are greater than screening_1 or screening_2 for each individual row.If the value is ...
- 1
0
votes
0
answers
51
views
Multiple Format Conditions with Conditional Formatting
I have conditional formatting applied to a column in LibreOffice Calc. There are two conditions. The first bolds the text and the second sets the background color. If the first condition is true the ...
- 1
0
votes
0
answers
27
views
Conditional Format - Date & Text combo
I'm trying to work out how to change colour on a cell if the date has passed a 14 day period and paperwork hasn't been received.
At present i have conditional formatting that will highlight if the ...
- 1
0
votes
0
answers
23
views
Excel: Conditional Formatting or Macro to delete/change information in one cell based on condition in another
I have a conditional format in place to highlight text in columns A - I as information is entered in column L. I would like to now delete or change the information in adjacent cells to be blank or 0. ...
- 23
1
vote
1
answer
29
views
How to mark specific rows in Excel
I'm trying to mark all the rows of this table:
AB-Table:
To this:
I want to do it via conditions (rules).
How can I do it? (if possible), Or - which rule I should write?
Thank you!
- 13
1
vote
2
answers
18
views
change 12 cells in row based on 1 word in a cell
I want to change the color of A1 - L1. Based on a word in cell F1
If F1 finds the word "Inspection" in the phrase "Chev 2500 Inspection" in that cell it would fill A1-L1 green.
Or ...
- 13
2
votes
1
answer
103
views
Excel: Conditional formatting formula based on text list
I'm trying to use conditional formatting to highlight text in columns A - I as the information is entered in column L. I tried
=ISNUMBER(SEARCH($L$1:$L$5,A1))
but it only reflects information ...
- 23
0
votes
2
answers
46
views
Highlight row if column value partially matches in another sheet column
I have a client with an old Excel 2010 sheet that needs to highlight rows on Sheet1 if the cell in column B partially matches a value in Sheet2, column A
Explanation
Sheet1
In column B we have partial ...
- 103
0
votes
1
answer
97
views
Conditionally formatting left align for a cell with text thats separated by multiple lines
I'm trying to write conditional formatting that will handle left aligning text in a cell that is normally in a range that's centered. The data in the cell could look like the following with each line ...
- 123
1
vote
1
answer
31
views
Excel: How to highlight value if greater than or less than previous column/row's last non-blank value
I have a vehicle data spreadsheet with 3 columns to record the Odometer.
Odometer during repair service or fueling
Odometer at the Beginning of a trip
Odometer at the End of a trip
There are gaps ...
- 13
1
vote
2
answers
117
views
Mass edit of Excel conditional format structure with formulas. Used the year 2022 in the formulas and need to change for 2023
I created a 17 tab worksheet for company locations to track monthly performance metrics against a budget. I used a reference cell as a condition to control conditional formatting of cells as well as ...
0
votes
0
answers
144
views
Libre office, automatically color cell based on value
I’m trying to make a planning grid with various tasks and I would like a task to be colorized to easily spot it anywhere else. Each different task should get a different colour.
I can’t find a way to ...
- 101
0
votes
1
answer
35
views
Color rows alternatingly according to change in column value – without hidden columns?
I have an Excel sheet with multiple columns, where in one column subsequent values can be identical or different, so that the rows form a number of groups. I would like the rows belonging to a group ...
- 799
0
votes
1
answer
28
views
Excel conditional formatting: contains one string but not another
In an Excel column that I've selected, I would like to apply conditional formatting to any cells that contain the string "US-" except if they contain the string "US-D". Based on ...
- 1,809
3
votes
2
answers
217
views
Excel: How does relative and absolute reference determine which rows are formatted?
In the image below, why are all K column values formatted and only the correct J column values?
I've read about absolute vs relative reference, don't see why the behavoir is different on my two tables....
- 316
0
votes
1
answer
136
views
How to format Excel cells selectively by character
I have the following Excel cells:
What I want to do is to format every cell that contains letters D and E with bold and red colors. How can I achieve that?
In the above example I only format the ...
- 103
0
votes
1
answer
74
views
Highlight a cell when information in that cell's row is duplicate in 2 of it's columns
I'm looking for a conditional formatting rule that would highlight a cell if data in that cell's row is duplicated in more than one column. Specifically for this sheet, I want the cell in column B to ...
- 1
0
votes
0
answers
43
views
Conditional formatting when date complete is later than due date in a range
I'm putting together a new spreadsheet for my team where I'm tracking "batches" and their approval through the system. The spreadsheet will list 200+ batches per month and each batch has a ...
- 1
0
votes
1
answer
71
views
Microsoft Excel Conditional Formatting for Dates and Prices
I'm looking to conditionally format a table following this general idea; I have short dates in one column and years in the headers for several other columns, Id like to highlight the cell when the ...
- 1
1
vote
3
answers
28
views
Microsoft Word Issue - Preventing Formatting From Automatically Being Altered When Transitioning from .doc to .docx File
I have Microsoft Word .doc files that are formatted perfectly. When transitioning the .doc files to .docx the formatting automatically is being altered/changed and I have to spend time fixing the ...
- 11
1
vote
1
answer
30
views
How can I create a table with values in all columns that change relative to one another?
I want to create a table in Excel where all the resulting values in the other columns change relative to the raw value I modify. Think of it like a multi-way conversion table, where you get to change ...
- 111
1
vote
0
answers
42
views
Excel: Icon conditional formatting based on column name lookup
I am trying to create a conditional formatting rule for a table which looks up a pass mark in another table and then compares the value to that pass mark. It is meant to be as general as possible ...
- 157
0
votes
1
answer
66
views
Excel Conditional Formatting - Using Formula as Part of a Cell Reference
I am trying to use conditional formatting to highlight a cell if it is blank and a cell in the first column of the same row is not blank. For example, if the conditional formatting is for cell D4, I ...
- 1
0
votes
1
answer
121
views
Automatic Shift Planner in Excel using Conditional Formatting
I want to figure out how to schedule shifts automatically in Excel (Native)
What I'm trying to achieve is this (Attached will help you visualize):
Screenshot describing what I have and what I want to ...
- 1
0
votes
0
answers
42
views
Automatically Change Numbers Color to blue in Excel if the cell contain a formula
The color of the cells changes automatically to blue because it contains a formula
How can I do that?
0
votes
2
answers
579
views
Changing Cell Color based on Multiple Cells
I would like to know how I can set the Cell A to auto change color to red if 3 out of 4 cells (B through E) have a "Y" value.
Screenshot provided for reference
- 1
0
votes
2
answers
53
views
Stop a formula when another is blank
In column A I have employees put a date in and I have formatted as date. In column H I want it to auto calculate 2 yr anniversary of the date they put into Column A which I have done using the cell +...
0
votes
1
answer
70
views
Excel: How to convert/format a column of text/values into a table made up by every nth line (n columns)
I'm having to fiddle with Notepad++, Excel 'Text to Columns', regex find replace. So painful.
Must be an easier way??
Ive got:
heading1
heading2
heading3
value1
value2
value3
And I want:
heading1
...
- 21
0
votes
1
answer
32
views
Formatting whole and decimalised numbers differently in Excel
I'm having some difficulty formatting some data correctly and after looking around extensively in similar threads such as here, I've come looking for help.
I have two similar datasets (X and Y) and ...
- 1
1
vote
1
answer
161
views
Outlook calendar conditional formatting, for the mettings where the attendees (other than me) didn't confirm their presence?
How can I highlight the meetings where my guests didn't confirm their presence? I would like to know when I need to sned a reminder to my clients before a meeting is up...
0
votes
0
answers
28
views
Excel conditionnal formating using a format reference table
I have a table with values:
, and a second table with reference values and the companion format:
The target result is:
Is it possible to do it without VBA?
The only solution I have found is: 1) ...
- 705
0
votes
1
answer
49
views
Conditional formatting date and text combined
Of all the possible combinations I have tried so far, every single one results in the same "there is a problem with this formula" error message.
This is what I am trying:
Conditional ...
- 3
-1
votes
1
answer
28
views
Highlight rows when all values are for Order Number
I have a spreadsheet with two columns. One column is Order Number and the other one shows its status. As shown in the screenshot below:
Sample Data Sheet:
I want to highlight all the rows when the ...
0
votes
1
answer
575
views
In Excel, how to apply graded color scale (with conditional formatting) only if cell value is greater than 5?
Suppose I have this dataset (the variable is not important in this case)
I would like to add a color scale for % Missing column, with light red being the lowest value and dark red being the highest ...
0
votes
1
answer
145
views
Macro to delete cells highlighted by conditional formatting?
I was looking for a way to automatically remove duplicates in a given range with a macro but all I could find : it's either remove duplicates from a list or remove duplicates from a cell.
I thought ...
- 3
0
votes
2
answers
286
views
How to automaticaly change the color of all "Yes" text to green using Microsoft Word?
I want to dynamicaly/automaticaly change the color of "Yes" and "No" text to coresponding colors. Yes - green. No - Red. All of this needs to be done in microsoft word.
From:
Yes (...
- 13
0
votes
1
answer
291
views
Conditional formatting with multiple rules, the order of rules changes when copy/paste, why?
Each cell has several conditional formatting rules. The order is critical since the format stops at the first rule that's true. For example is less than 0, red, if cell A <>B, bold, etc. When ...
-1
votes
1
answer
313
views
Add until a certain value is reached and return the content of another cell
So I have the given table.
The formula will be in B6. The problem look like this: first I need to test if B2 is >= than B5. If it is I need to return B1 (Week 1), else add B2+C2 and test if the ...
- 1
0
votes
0
answers
76
views
Why does my conditional formatting stop working when I use the format painter to copy from one Excel sheet to another?
I have a macro I created that has worked perfectly for a few months. It copies formatting and conditional formatting from one Excel sheet to another sheet that has raw data. The macro still runs but ...
