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

learn more… | top users | synonyms

2
votes
1answer
172 views

Excel conditional formatting when part of validation list

I'm trying to use conditional formatting on a cell that is populated via a validation list. It will not format. I try the exact same formatting on another cell which is not populated from a drop ...
1
vote
1answer
21 views

Cannot use Conditional Formatting in Workbook

The problem is simple enough to state. When I select a range of cells (as numeric values or indeed as values calculated from a formula), I cannot conditionally format them. What I want to do is to ...
1
vote
1answer
45 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
1answer
39 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 ...
1
vote
1answer
132 views

Color-based text in Excel cell

Looked through available options, but failed to find the one in a format I would understand steps. Working with Excel. Need to have cell changing color based on specific wordS (not one). For example ...
1
vote
1answer
30 views

How to get Excel conditional formating to recognize boolean operations

I have constructed a spreadsheet to color code incoming scientific data based on different levels of criteria. My problem is with data coming in as 'less than'. For example, if the data shows ...
1
vote
1answer
378 views

Align rows from different columns (which contain some cells that have identical values) using simple formula in Excel

I have 2 tables in Excel and I am trying (via Excel formula) to match/align some rows (ones that contain identical letters for the sake of the example included below). Btw, I don't mind aligning Table ...
1
vote
1answer
670 views

Excel VBA - Conditionally format a cell using 2-color scale based on 2 values (max/min) on other cells

I'm trying to write VBA codes to conditionally format (2-color scale) cell A1 based on its value that between is >= cell A2 and <= cell A3. I'm using cells A2 and A3 so I can change the specific ...
1
vote
1answer
417 views

How to use Conditional Formatting to change text color to match conditional fill color

I have used the Conditional Formatting to change the Cell fill color based on the percentage number. However, I would like to hide the text so I just have a bunch of colored squares with no value ...
1
vote
1answer
763 views

Alternative to cell highlighting using conditional formatting in Excel without causing freeze/crash

In column A, I have a value and I want to highlight if it doesn't match the same value in column B. I'm using the formula below in conditional formatting which works great. =ISERROR(MATCH(A1,$B:$B,0)...
1
vote
1answer
87 views

Get conditional formatting to analyze rows separately

I have a calendar and I am trying to fill the background of the cells based on dates on another sheet. I have gotten it to work by entering the dates in a columns, naming the range (lets says "Dates"...
1
vote
1answer
310 views

Advanced data consolidation in Excel

I need to Combine/Consolidate Data dynamically between over 20 separate Excel workbooks. The Column names and their relative position at the top row are the same. The positioning of each word under ...
1
vote
1answer
966 views

How do I use Conditional Formatting based on due dates in Excel 2013?

I am trying to format cells in Excel 2013. I want the cells to get colored as green, yellow, and red based on how close they are with the target date (January 13, 2015 in this case). I am unable to ...
1
vote
1answer
794 views

Is there anyway to format negative numbers in red in a table in Powerpoint 2010?

I have tables of data and I want the negative numbers to show up in red (similar to what you would do in Excel). Does powerpoint have this capability?
1
vote
1answer
162 views

How to combine data from two sheets and conditionally format rows based on sheet of origin

I have 3 sheets in Excel "Open", "New", "Combine" "Open" Sheet (Old list) Ticket ID | Priority | Department | Status 36009 | 1 | Finance | 01-Open 34781 ...
1
vote
1answer
51 views

Conditional formatting excel conundrum

I have a list of values in excel. I would like to highlight a cell if its more than 1.5 higher or lower than the value before it or after it. Is this possible? Thanks guys!!
1
vote
1answer
629 views

Recolour a single occurrence of a recurring appointment in Outlook 2010

Brief: Recolour a single occurrence of a recurring appointment. I have the following recurring appointment: Subject: Maths 104 Date: N/A (series) Time: Thursday 12pm Recurring: Weekly (4th March to ...
1
vote
1answer
262 views

Excel, Pasting text with hyperlinks, conditional formatting for doubles

I have a list of names that I paste, individually, from a site into a column of cells in a table. I have conditional formatting to tell me if there are doubles. However, when I copy straight from ...
0
votes
1answer
29 views

Microsoft Excel TIME related Conditional Formatting

I'm maintaining an attendance table in the following format. 01 Wed IN | 01 Wed OUT ==========|=========== 08:27 | 17:16 08:36 | 14:31 08:38 | 17:07 08:32 | 17:05 08:47 | 17:05 ...
0
votes
1answer
26 views

Applying conditional formatting to individual rows

I'm trying to apply conditional formatting to a few hundred rows of data, but I want to keep them separate. Meaning, if I want to coloring cells based on their proximity to the average value, I want ...
0
votes
1answer
30 views

Conditional formatting in Excel combining 2 rules?

I want to format my dataset (22x12 values) with the 3 color rule, but based on the values of another dataset so that the color can be used as additional information. Here my example. I want to ...
0
votes
1answer
55 views

Formula or VBA for cell formatting using value based on a cell but formatting from an other cell

I have a fixed set of values, (0%,20%,40%,60%,80% and 100%) in column E. If I fill a cell in column E with any of the above values, the cell G should pick formatting from another cell. For example, ...
0
votes
1answer
61 views

Outlook: Shared Calendar conditional formatting

Situation: My work group has a shared conference call dial-in number. To avoid double booking the dial-in number, we have to reserve time in a shared calendar. All users have read/write permissions, ...
0
votes
1answer
40 views

Format entire row in Excel Table if row is empty

I have a Table (as opposed to a Range) defined in Excel 2010, named Table1. The table has blank rows separating groups of 3 to 5 rows with data. Note that not every column in every "non-blank" row ...
0
votes
1answer
210 views

Displaying data in Excel graph only up to current date?

I have an Excel chart that displays 5 sets of data in a single scatter plot, where the X axis is the date of occurrence. In my table, I have both actual values from previous dates and projected values ...
0
votes
1answer
36 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 ...
0
votes
1answer
333 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 ...
0
votes
1answer
53 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 =DATEDIF(F2,TODAY(),"...
0
votes
1answer
266 views

How do I superimpose a conditional formated heatmap based on one set of values over a different set of values in Excel 2013

I would like one cell to be formatted with a gradient color based on the value in another cell. For example, I would like cells A1 and A2 to be highlighted based on the values in B1 and B2. If I ...
0
votes
1answer
81 views

EXCEL: Icon Conditional Formatting Based on Range of Values

I am creating a spreadsheet for work and I need to format cells such that I get a green check mark when the value in the cell is between 100 and 101, yellow ! if it is between 97 and 100, and red X if ...
0
votes
1answer
209 views

Finding Clustered/Consecutive Values in Excel

I am trying to find values in an Excel spread sheet where numbers greater than 0 will be highlighted. However, those highlighted must be clustered, consecutive numbers which should be (at least) three ...
0
votes
1answer
35 views

Apply conditional formatting to one cell based on part of a text in a cell

I have a spreadsheet containing a bank statement. In C I have a description of what the transaction is for sometimes just a word and other a sentence. In D I have money coming into the account and E I ...
0
votes
1answer
48 views

How do I create a conditional format with 2 columns

I am trying to create a rule that would highlight a cell under these conditions: Column B>1 & Column C=O I want Column C to highlight if they meet these two conditions. Can someone help?
0
votes
1answer
52 views

Conditional Formatting for Excel Greater than

I have applied a rule if the cell is greater than 50 fill with cell with RED. The cells are populated from another location. When I apply the rule the blank cells show up RED? Any help would be ...
0
votes
1answer
673 views

IF AND conditional formatting not working - Excel 2013

Okay so I’m trying to format cells that are blank and meet the logical test. Here’s the formula: =IF(AND($B2="Y", ISBLANK($C$2:$F$172)), TRUE, FALSE) If both tests are true (B column = Y and there ...
0
votes
1answer
97 views

Can I use conditional formatting to format a cell based on color in the cell itself and the cell before?

Conditional formatting Excel 2010 how to format a cell based on color in the cell itself and the cell before. I have with Conditional formatting marked a start cell and end cell with red I want to ...
0
votes
1answer
119 views

Excel conditional formatting for repeating values

I have a table of data where there are 50 rows and many columns. Each column's value is sorted by the most important result at the top. These are names of people in sports. I would like to see ...
0
votes
1answer
453 views

How to use conditional formatting to highlight specific days of the week AND time periods?

This answer regarding formatting on date time information Excel 2010 Conditional Formatting - TIME is a very, very technical answer that, in truth, I don't really understand! Hey-ho, I can deal with ...
0
votes
1answer
181 views

Excel 2010 Conditional Formatting

I have a spreadsheet for taskers with due dates. I have used conditional formatting to change the font color to red for pass due and yellow for approaching due dates...now i need to add another ...
0
votes
1answer
96 views

Conditional formatting

What I am looking to do is have a conditional format set up so that if row G contains the value "In progress" "With 3rd Party" or "Identifying" and row H, J or K contain no value then highlight rows A ...
0
votes
1answer
2k views

Conditional Formatting for one cell value in a list, another cell blank

Looking for how to do Conditional Formatting for the following rule: If a number in a cell equals one of a list of particular numbers, then information MUST be entered into an additional cell. ...
0
votes
1answer
267 views

How to suppress repeating values in a manner that takes into account previous conditional formatting? (Google Calendar-like scheduling blocks)

I'm in the process of creating a scheduling template. I'm trying to figure out how I create a conditional formatting formula for suppressing repeating values that takes into account the conditional ...
0
votes
1answer
707 views

VBA Macro to sort and apply conditional formating to a range of cells with dynamic number of rows

I have a range (the image below). Please note that: Range is generated by another application, so number of rows is ever changing, and is not formatted as an Excel 'table' The number of columns, ...
0
votes
1answer
52 views

How can I set up this conditional formatting in Excel 2010?

We create sections by highlighting an area in Excel 2010 and clicking ALL BORDERS. We want to set it so that any time you type "REPLA" between columns J and Q, the line that "REPLA" is in will Fill ...
0
votes
1answer
161 views

How to change a row of cells on excel 2010 depending on different cell data

Can anyone help me with a problem I'm having on excel 2010 please? I am trying to change the colour of part of a row of cells when certain data is input. For example I want cells A13 to G13 to ...
0
votes
1answer
524 views

Excel - Using condtional formatting in a count down of the date

So i am using Excel Mac 2008, i want a formula where i enter a date and if the date is less than 5 days from today, it turns bold and red. can anyone help me figure this out? I have a formula that ...
0
votes
1answer
175 views

How do you have a conditional formatting rule in Excel apply to a discontiguous range of cells?

I have an Excel workbook with 10 worksheets. Each sheet has a column named status. Depending on the value of status ("on time", "at risk", "completed"), I want to format the cell background with a ...
0
votes
1answer
530 views

Excel cell formatting to fill color

I'm doing some excel formatting, with below formula being used: =IF(OR(ISBLANK(E23),ISBLANK(E24),ISBLANK(E25)),"Section Incomplete","Section Complete") Basically, When the cells E23, E24 and E25 ...
0
votes
1answer
379 views

Conditional Formatting to highlight dates past due

I have a spreadsheet which indicates when dates listed in Column N are coming up within the next 30 days (red, italic text) or are overdue (red, italic text and yellow cell fill). I have achieved ...
0
votes
1answer
2k views

Conditionally formatting a cell in a pivot table based on a range of cells grouped by a Column Label

Within my pivot table I currently have cells conditionally formatted- Value=1, Green and Value=0, Yellow. I would like to conditionally format based upon all the values within a row label underneath a ...