A feature in Microsoft Excel, LibreOffice Calc, and some other spreadsheet programs that allows the user to automatically add color, text styles, and so on to certain cells or ranges of cells based on the data in the spreadsheet.

learn more… | top users | synonyms

0
votes
3answers
40 views

highlight birthday in a referenced cell

in Excel 2003 in worksheet1, I have a conditional formatting that highlights a cell when today is the birthday in cell A1 date of Birth in cell B1 age with the formula: =DATEDIF($A1,TODAY(),"Y") ...
1
vote
1answer
24 views

Why does Excel automatically apply conditional formatting to other cells?

I construct following table in Excel 365: I select the entire column D and add conditional formatting. Whenever I fill out an additional row, the cell in column D is coloured and the other ones ...
1
vote
0answers
19 views

Is it possible to use conditional formatting in Word 365?

Is it possible to use conditional formatting in Word 365, as it is possible to do in Excel 365? I know that you can add an Excel sheet inside a Windows document, and use conditional formatting inside ...
1
vote
1answer
17 views

Conditional formating of excel row based on the value of the first cell of the row

I want to apply a conditional formating for a row only if the first cell (A column) contains text starting with Volum. Is there a way to do such a thing ? Thanks in advance.
0
votes
0answers
20 views

Excel Conditional Formatting disappears unless smaller dataset in filter

Conditional Formatting on a Power Pivot (Excel 2016 32-bit) using a Color bar is working nicely when results are page filtered to a smaller subset. But when nothing is filtered, the CF disappears, so ...
1
vote
1answer
35 views

Conditional formatting between 2 sheets

I've got a conditional formatting question I'm really hoping someone can help with. I've got a workbook with 3 sheets - "Total Data", "Pivot Table" and "Expired Data". Pivot Table is extrapolated ...
1
vote
1answer
39 views

Multiple conditional color formatting on a cell using IF… IF… ELSE

I've got three columns of Names, gender, DoB. Gender column as either "M" or "F" keyed in. DoB column has the date of birth mentioned as dd-MMM Color formatting of DoB column needs to fulfill the ...
0
votes
1answer
42 views

How to change cell function [not data] through drop down list

For my very first post I may have a slightly complex question. I've had a decent look around, and either excel doesn't have the functionality or I've got my terms mixed up. I want to create a ...
2
votes
1answer
23 views

How can I use conditional formatting or a macro to italicize duplicates (but not the original) cells?

I have a spreadsheet in which there are many duplicates (intentionally), and I would like to highlight the duplicates but not the first instance of a cell. Below is an example row: A A A A A B B B C ...
1
vote
1answer
35 views

In excel 2010 how do I change the cell colour to red if the date entered is 2 weeks or more in the past? [duplicate]

I have a spread sheet and I want the colour of the cell to change to red when the date entered is two weeks (or more) ago as this will immediately show me when work is overdue so I can chase it up. ...
2
votes
2answers
72 views

How to do a conditional formatting in a table from a graph?

As you can see in this example below, I would like to be able to put in red the negative numbers that are in the table below the graph. I would like to apply a conditional formatting on this table ...
1
vote
1answer
22 views

Selective conditional formatting when midnight is time in the cell

I have created a sheet where the first column is an hourly timeline starting with a user entered time and date. The user inputs the time and date in cell F4. Subsequently the timeline starts in cell ...
0
votes
0answers
16 views

Conditional formatting from a clock on Excel 2010

I was wondering if anyone can help me with my spreadsheet. I have set up a macro in cell L1 to run a clock the programming is as follows: Dim running As Boolean Sub clock() running = Not ...
0
votes
1answer
16 views

Excel nested IFs

I'm trying to combine several IF formulas with an IF(AND formula but struggling. I can manage Nested Ifs or an IF(AND formula but can't seem to combine them. I want to say if L2 equals 1,3 or 4 then ...
1
vote
2answers
18 views

Fill a date-filled cell red if older than 30 days and no date paid entered in another cell

I have two cells in Excel that are for dates (date billed and date paid). I need the date billed cell (say A1) to fill red if it contains a date and that date is older than 30 days and nothing has ...
0
votes
2answers
37 views

How to make a formula in one cell only run when another cell has a content

Hi I am using 2013 excel and have a formula in W269: =product(u269,v269)+50 However I need this formula to run only when T269 contains a value (text not a number). Here's some more details in case ...
0
votes
1answer
64 views

Conditional formatting of PowerPoint-table

Related to this question, I wonder if there is any way to apply conditional formatting to a table in PowerPoint, without importing an Excel-table. E.g. to change the background colour of a cell in the ...
0
votes
0answers
35 views

Conditional formatting to highlight differences between 2 pivot tables in Excel

I have an Excel issue I hope somebody may be able to help me with please? I have 2 pivot tables that both contain the following fields: 'Provider ID' in the Rows area, 'Month' in the Columns area ...
0
votes
0answers
21 views

EXCEL: How can I use a custom function created in VB as formula for conditional formatting?

I created a VB script to validate a personal document from my country (just like the Social Security number in USA). It is BOOLEAN, receives the number as param and returns only TRUE or FALSE if it's ...
1
vote
1answer
28 views

Excel Conditional formatting if in list

I have a list of values J1:J100 and another list of values E1:E75 If a cell in column J matches a cell in column E, I would like this cell to be highlighted. Any ideas what formula to enter into ...
0
votes
1answer
16 views

Duplicate and Unique formatting in same column?

Is it possible to apply both a duplicate and a unique format to a column? I know that a value can only be one, but what if I'm applying the unique rule to say, Col 1 and Col 2 (checking for values ...
0
votes
0answers
40 views

Conditional formatting of pivot table cells based on value of a separate field

I have a pivot table which has, for the purpose of this question, "document-ID" as a row label, "person" as a column label and "date signed" as value field. Is it possible to give each cell containing ...
0
votes
1answer
26 views

Excel Conditional Formatting for Date colums

I have 2 columns with dates and I want to apply conditional formatting to all values where the date in one column is bigger than the date in the other column. So, when the dates in "Actual End ...
0
votes
0answers
18 views

Condtional formatting

I have a question on how do you write a formula in a conditional formating if it sees the text funded in colume h I want to highlight column a the loan number when it sees the world funded only for ...
0
votes
1answer
29 views

Define conditional formatting formula in Exel outside of conditional formatting formula bar

It is possible to use a formula to determine which cells to format. I don't think the formula bar of the CF menu is very user friendly for editing formulae. My current solution is to write / edit ...
-1
votes
1answer
60 views

How to compare values and apply formatting when one cell is a formula?

I need to apply conditional formatting in one cell based on its comparison against another cell that is of a different format. For example; Column A contains cells with formula. Column B contains ...
0
votes
1answer
53 views

Conditional formatting on blank cells in non-blank rows

I'm looking for how to apply conditional formatting to blank cells - but ONLY if the row they are in is not completely blank. For example, I'm making a project tracking sheet, and I want incomplete ...
0
votes
0answers
10 views

data bars conditional formatting in Excel

I need to format cells in a column with data bars of two different colors, depending on cell values in previous column. For example: if the value in the cell on the left is greater than zero, then ...
0
votes
0answers
48 views

Conditional format a single letter without other cells containing the same letter

I need to conditional format my spreadsheet so that all the Nos ( N ) and all the Yes' ( Y ) are formatted without other cells containing the letter n or y also being highlighted. I would like to ...
0
votes
0answers
7 views

Conditional formatting icon sets of one row applied to other rows, icon sets

I have a question on how to apply conditional formatting icon sets of one row to other rows without using format painter? The issue is that I have over 100k rows. For example, the data is compared ...
0
votes
1answer
55 views

How to use conditional formatting to search a specific value in a range in ms excel?

I have values in the range K5:K333. I want the value in cell S5 be searched in the range and the corresponding cells of the range being formatted. I am using conditional formatting's "use a formula ...
2
votes
1answer
50 views

Highlight rows that don't match other sheet

I'm not sure if this is possible, but I have two spreadsheets that I need to compare in a few different ways. Here is the scenario: **Sheet 1** Column O=Claim Number; Column P=Reserve Indemnity; ...
0
votes
1answer
50 views

Highlight row if ID is found on other sheet

I have one Excel file that contains 2 worksheets. Worksheet 1 columns: computernames Username E-Mail comp1 username mail@mail.de comp2 username2 mail2@mail.de Worksheet 2 columns: ...
0
votes
1answer
97 views

Outlook “conditional formatting” for meetings without other attendees

I'm trying to get meetings with other attendees (other than myself) to show up in a special color. My "own" meetings (without other attendees) are mostly just reminders, which I can easily move, but ...
2
votes
2answers
43 views

Highlight duplicates only if the header is the same

I'm attempting to use Conditional Formatting to highlight a duplicate entry if and only if the Header to both columns are the same. In my example below, this is a season long NFL contest of picking ...
0
votes
0answers
32 views

Outlook Query to highlight messages that mention me?

In essence, I want to do some conditional formatting on messages that mention me. Below are 3 sample Messages (Bodies). The first two should be purple, the last one should not be purple because I ...
1
vote
1answer
91 views

Highlight Cells with Red Text

I have a column of text in which some characters (not cells) are in red font. Is there any way to highlight the cells which contain red characters via conditional formatting? VBA solutions would be ...
2
votes
2answers
64 views

Excel conditional formatting rows to highlight weeks in different colours

I am trying to automatically format the rows of my worksheet based on the date in the A column. I am using the following to highlight the weekends. =WEEKDAY($A6,2)<5 This works however I also ...
0
votes
3answers
688 views

Conditional formatting with multiple conditions

I have to set a simple formatting in excel: colour cells if the value is = to another cell. The question is that I would like to colour the cells if the value equal to A1 or B1 or B3 Is it possible ...
0
votes
1answer
30 views

Prevent Outlook calendar conditional formating happening on iCal feed

I've got two calendars in Outlook 2010: My own calendar (which comes from the company exchange server) My personal calendar (which comes from Google in the form of an iCal feed) If I apply ...
1
vote
1answer
46 views

Copy Conditional Formatting 3-Color Scheme to another tab

I have one sheet, Tab 1, with a 38x12 grid of values ranging from -30 to +30. I applied the traditional 3-color scheme conditional formatting to the data, which shows all shades of the spectrum ...
0
votes
0answers
18 views

Microsoft Excel 2013 - Auto-generating a page with parent formating

I have a multi-line activity log which is created using merged cells and colored borders, and often times the activity log follows on to a new, un-formatted page. Is there a way to have excel create ...
0
votes
1answer
42 views

How do I get the cells with no dates to have no color until the date is entered? All of the unused cells are red

=DATEDIF(F2,TODAY(),"m")<=47 THE CELL TURNS NO COLOR =DATEDIF(F2,TODAY(),"m")>57 THE CELL TURNS RED =DATEDIF(F2,TODAY(),"m")>54 THE CELL TURNS PINK WITH RED WRITING ...
0
votes
2answers
127 views

In Mac Excel 2011, how to format cell as percentage or currency based on content of another cell?

As far as I can tell, the Conditional Formatting feature doesn't support percentages. You can format styles (color, font, etc.), but not the actual content presentation itself. I have two columns, ...
0
votes
1answer
44 views

Excel formula related to conditional formatting

Column A has 10 numbers expressed as percentages and is conditionally formatted to highlight the top 40%. I want column B to show a "1" next to the corresponding highlighted top 40% of numbers in ...
0
votes
0answers
57 views

Excel 2007 Conditional Formatting On Formula Not Updating When Cell Updates

I have set the following conditional formatting rules: =$B97=1 Set Format (Custom) ">" @ On cell =$D97 =$B97=2 Set Format (Custom) "> >" @ On cell =$D97 =$B97=3 ...
0
votes
2answers
69 views

IF statement with multiple criteria and multiple possible results

I have a spreadsheet and I need a formula to give me one of three possible results (good, neutral, bad) based on data from two cells. MTD and YTD on budget would be good, MTD on budget & YTD below ...
1
vote
1answer
18 views

Conditional Formatting in Excel via a different worksheet

I've been trying to figure out how to make a cell bold and color red based on conditions entirely in a different worksheet. For example, I'd like Sheet1!A1 to be bold and red when Sheet2!A1 = ...
0
votes
2answers
174 views

How do I highlight the max values across every column in a pivot table?

Looking for a way to use conditional formatting to highlight the max value in every column of a pivot table.
0
votes
2answers
58 views

Is it possible to have an Excel formula dependent on value input?

Is it possible to have Cell G24 recognize the number in D24, and do its math depending on the size of the number, using the in Cells B37 through B42? I have a basic spreadsheet for cataloging sales ...