condition formatting

Hello, I am using Excel 2007 and have a set of review dates for a number of people. Each person must have their next review within 10-12 weeks. I'm trying to set a conditional format on the next review date with the following; * if less than 90 days - highlights green * if less than 40 days -...

Hello, I have several sets of data and want to create a set of navigation buttons that conditionally format to a Red, Amber, Green colour dependent on parts of that data. Ideally I would also want to display a single number in the button too. Any ideas anyone? Thanks in advance

I have set up a Gantt formula by the day. I have also set a conditional format that highlights todays date in the spreadsheet. My issue is that it only highlights the actual date, I want it to highlight the whole column. Any suggestions? I have a feeling I am not describing this well so please...

Today is 14-Nov-12 Hello Forum, appreciate some help with this headache ;-) The office has a large spreadsheet where Column A has a "start date" and Column B "Clearance Date" We would like to see a red font for those dates that have passed the current date. A yellow cell for dates that are...

Hi All, Using 2010 on Vista. I have been playing around with this for far too long so thought I would get your advice. Column “D” contains a Data Validation list which has two options “Quick” or “Key”, - No issues with this. - Row 7 is the first possible entry point (due to headings...

I need for Example: if J4 has data in it then there must be something entered in K4 or a message box will appear saying" MK# Must Be Entered") and if there is data into K4 there must be data entered into J4 or a message box will appear saying" Drawing Must Be...

<TBODY> Benchmark</SPAN> Average</SPAN> Variance</SPAN> Cumulative Variance from Benchmark</SPAN> £568.00</SPAN> £569.00</SPAN> +0% OVER </TBODY><COLGROUP><COL><COL span=6></COLGROUP> Hi I have conditional formatting on Cumulative Variance so that if it says OVER then the cell...

Good afternoon, all. I have what I thought would be an easy thing to do, but I am having some troubles. I've researched and read many threads here to see if I could find it before posting here, but I've not had any luck. I'm on Excel 2010, too. In my spreadsheet all records are unique rows...

I have a worksheet with 3,000 rows.. and each row has a sparkline... as such, it takes up quite a bit of processing power (and a few seconds) to display them all after I make any changes to the formula which they are based on. To make my life easier and speed things up a bit, I was wondering if...

I have a pivot table that shows values & no values, fair enough Some of the values = 0 (zero) due to a calculation in the sheet Most Values > 0 Some Values = <BLANK>because they were not sold that week I was under the impression that <BLANK><BLANK>was different to 0 (zero) but if I run...

Hi! I have got stuct in my try to get a cell to change color when I have three cells that is a part of the condition for changing. I have tryed some conditionall formating and I have try to write a function but do only get it to work half on half. The problem is as follow. I have columns A,B...

I have a spreadsheet with address information, with columns for Address Line 1, Address Line 2, City, State, and ZIP. I'd like to combine each of the columns into a single, formatted column, with line breaks in the address as follows: Address Line 1 (break) Address Line 2 (break) City, State...

Hello all! To give you an idea of what I am trying to do, let me break down what I have... I currently have a workbook with multiple spreadsheets used to track requests received, and follow them throughout their life... sort of a "help desk" type of tracker, where we assign a ticket number and...

I have a report that I download once a week however could be using it for a few days each week. I recorded some conditional formating but used =today(). Is it possible to change it so it makes the condition based on the day it is ran (monday) so that it doesn't change when I reopen the now saved...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

Hi I am new here and am only a basic excel user. I was wondering if anyone could help me with the following: I have a column of dates. I would like to have todays date back ground colour high lighted, and then tomorrows date back ground colour changed tomorrow. if this makes sense: If...

Hi all, In my on-going work project (that i thought was finished ><) I have code that basically does this: IF cell1 = cell2 THEN highlight entire row Blue. IF cell3 = cell4 THEN highlight entire row Red. This obviously cause problems when both are true as the as the you can't see both...

I'm fairly new to Excel and have been tasked with comparing to huge data sets (same workbook, Sheet1 & Sheet2) that have the same Unique Identifier but can contain varying dates. Sheet1 Column A contains the same set of Project#s as Sheet2 Column A. And Columns B through HH contain...