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

0
votes
2answers
28 views

Custom formula for databars in Excel

How would one go about using a custom formula to determine the format conditions for databars? Meaning, in Excel under "Conditional Formatting" there's a format called "Data Bars". However, you ...
0
votes
2answers
56 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
2answers
303 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
2answers
410 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
63 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 ...
0
votes
2answers
88 views

Excel 2010 Custom Formula / Conditional Formatting to highlight data that is greater than Twice the Value of Original Cell

I am trying to figure out how to indicate cells that are greater than twice the value when compared to a specific cell. For example, a value of .1 compared to .18 would be OK but .1 compared to .2 ...
0
votes
2answers
214 views

Selectively find duplicates across columns

Column A has the product ID. There are 102 other columns with other data. Column A will be unique unless some data was changed. In that case, there will be 2 rows with 99% of the columns are identical,...
0
votes
2answers
748 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
2answers
442 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
207 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 ...
-1
votes
2answers
3k 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 ...
0
votes
1answer
552 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
380 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 ...
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
2k 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 ...
0
votes
1answer
584 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 ...
-1
votes
1answer
146 views

Formatting - conditional - vlookup- values from one cell to another different worksheets based on value

I would like to be able to enter a part# in column L of sheet 2 and a formula would look through column A of sheet 1 for a match, and then return their price from column F of sheet 1 into column K of ...
-1
votes
1answer
29 views

Conditional formatting (alternating between only two colours) of rows depending on cell values

How do i get conditional formatting done depending on values of cells. I need to get the cells (and their rows) formatted in only two colours Say,A1 has Colour1 if A2=A1, then A2 should get ...
-1
votes
1answer
174 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 ...