Tagged Questions
2
votes
3answers
104 views
How to format a date field based on whether the date has passed?
I am trying to create an Excel spreadsheet where, when I input a date:
if that date is within 30 days it will go yellow,
if the date has already gone then it goes red, and
if the date is more than ...
1
vote
3answers
142 views
How to create a conditional format in excel 2007 from another cell
I have a sheet with 4 fields spanning A3:D3
in D3 I have a conditional format that turns the cell yellow if it equals the word "no contact"
How can I get Cells A3:C3 to also turn yellow if this is ...
1
vote
1answer
574 views
Excel 2007 - Conditional Formatting: Compare 3 columns with text - find unique values
I have a spreadsheet with three columns, each column listing the folder names found on a server.
Server1 | Server2 | Server3
--------|---------|---------
A | | A
...
0
votes
2answers
397 views
Setting background colour of cells based on their string length
Suppose I have this column of data
Canada
Chile
China
...
How do I set the background colour of each cell if the length of the string in it is greater than say 5? ('Canada' cell would be ...
2
votes
1answer
550 views
Conditional formatting to highlight the whole row
I would like to highlight the whole row 5 if J5="T".
I used to do it with the old Excel, the 2010 conditional formatting ignores it. So my rule is like this and it does not work. I used the formula ...
0
votes
1answer
967 views
Excel INDIRECT function and conditional formatting - highlighting a row
I'm having an issue with conditional formatting using the INDIRECT function. I'm doing something similar to Using INDIRECT and AND/IF for conditional formatting , but the only answer there isn't ...
0
votes
2answers
138 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
1answer
364 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
vote
3answers
157 views
Excel Conditional Formatting for Cell condition in Range
How do I reference another cell in my conditional formatting?
I want an entire range to highlight in green if a particular cell in that range is populated with "y".
1
vote
2answers
352 views
Excel conditional formatting of row
Can someone please tell me how to highlight multiple cells in a row based on some values in any one of a given number of cells?
For example, if in Row 2 any of the cells from D2 to L2 have value "A" ...
