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
2answers
508 views

conditional format that would highlight an entire Row based on two criteria

Can someone help me please with a conditional format that would highlight an entire row in Excel 2010 if column B on my spreadsheet has any of these Letters (A,B,C,D,E,F,G,H,Z) and column C has the ...
0
votes
1answer
148 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
220 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
625 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 ...
0
votes
2answers
301 views

Highlight row when two columns contain specified values

I have 2 columns "N" and "O" . Both columns can contain "x". If column N has an x and column O is null then highlight the line. This should apply to the entire worksheet. Thanks so much in advance. ...
0
votes
1answer
1k views

Excel 2007 conditional formatting rule using formula to highlight a row based on matching text between columns

I am checking accountability of whether my office is creating source acknowledgement reports "C", recommended whenever a reference document "A" is read, and required whenever an article "B" is ...
0
votes
1answer
274 views

Conditional Formatting with more than one variable

If ( cell A10 =2 ) AND ( cells C10:c15 through d10:d15 are blank) Then color cells c10:15 through d10:15 red I can do one or the other but can't figure out how to make it meet both criteria prior ...
0
votes
0answers
19 views

How to apply Conditional Formatting to a row of data if a certain cell is blank [duplicate]

Possible Duplicate: Conditional formatting to highlight the whole row Here's the problem I am facing: I want to highlight A1:M1 if L1 is blank, A2:M2 if L2 is blank, A3:M3 if L3 is blank, ...
0
votes
2answers
208 views

Restricting symbols allowed in cells of Excel spreadsheet

I need to format some Excel cells to allow currency (decimal point) only to be entered. Some employees completing the form enter a colon (:) instead of a decimal point which then results in an ...
0
votes
2answers
178 views

Finding duplicates in a column where the cells hold a formula

I have a workbook with 3 sheets. Sheet "PS", column A contains a list of player names that stays static. Each week, each person in column A sends me a name from an available list. They are allowed ...
0
votes
2answers
203 views

Conditional Formatting Non Contiguous Ranges

I have a large spreadsheet, which came prepopulated with data. What I would like to do is the following. If I select I7:15, and apply this conditional formatting Cell Value is equal to =G7, colour ...
0
votes
0answers
32 views

Excel: use formula in cell format [duplicate]

Possible Duplicate: Excel: use formula in cell format Is there a way to use a formula as a cell format? AFAIK, conditional formatting allows only static format applied based on some ...
0
votes
1answer
609 views

Outlook 2007 - Conditional Format based on Users declining a meeting

I recently set up a meeting with a colleague but must have ignored the fact that he had declined. So I showed up to the meeting alone. Is there any way to conditional format my Outlook 2007 calendar ...
-1
votes
1answer
34 views

Conditional Formatting from Helloh, for a Noob

I'm going to try my best to explain what I need to figure out. Also, for you to understand exactly how mind bending this is for me, I haven't used an Excel formula since 2005/2006ish. We're doing a ...
-1
votes
1answer
2k views

Changing a row's color depending on the value ( TEXT ) of a cell [duplicate]

In a cell, I have the choice of YES and NO for values. I would like to know how to change the background color for other cells in the same row depending on the value of the first without changing the ...
-1
votes
1answer
448 views

Excel 2007 conditional formatting formula problem

I have the following problem. I have a sheet where the current month should be highlighted. For this I used the formula for conditional formatting. The formula for the first three months is like this: ...
-1
votes
1answer
725 views

Set an Excel cell's color based on multiple other cells' colors

I have an Excel 2007 spreadsheet for a list of products and a bunch of factors to rate each one on, and I'm using Conditional Formatting to set the color of the cells in the individual attribute ...
-1
votes
1answer
170 views

Can someone tell me why this conditional formatting is wrong? Date ranges

I'm just literally doing a 3-color scale like so: Minimum: =($L$3-TODAY())<7 Midpoint: =($L$3-TODAY())<14 Max: =($L$3-TODAY())>14 I thought this would be correct but it won't format ...
-1
votes
2answers
2k views

Excel conditional formatting comparing date and time to current date and time

I have a style sheet in which I have to dates with times ----------------- 29/09/2011 12:00 29/09/2011 14:00 ----------------- If current date and time is 29/09/2011 11:50 then row is green If ...
-2
votes
1answer
92 views

Conditional date formatting

The following needs to happen: Enter a goal date in cell C1 and enter actual completion date in D1 when project complete D1 will remain blank until project is complete. If D1 is blank: STATE 1 -- ...
-3
votes
0answers
28 views

How can I get Excel to auto-fill a column based on text entered in another column? [closed]

I am looking to Format a column of text in excel for example A ABC123 123DGF ABC124 NMO445 B Corp Acct Corp HR I want excel to notice the text entered in column A and then ...