I have a spreadsheet of flight schedules (it has person's name and other details). How do you highlight the row within the table when a cell in the row has today's date and another condition when date is today+1
I am working on a spreadsheet in Excel 2007 and i am trying to use a formula in the conditional formatting that will highlight a cell if the date is prior to today's date and the next column over is no. the formula i am using right now is =IF(F2>TODAY(),IF(G2="NO",TRUE,)). the problem i am having is that it is highlighting all cells that have a date and the next column over is no.
i can't figure out how to get it to do an if this, then that function correctly. one other thing that could potentially be causing my problem is that the cells. I am trying to have highlight are calculated themselves based on a formula. see the attached spreadsheet for information.
I have a spreadrsheet (sample attached) which populates a calender due to columns on seperate sheets being filled with text and corresponding dates. I started using conditional formatting to highlight certain conditions but soon realised I need more than 3 so I tried looking into VBA - and failed.
All the cells in the calender have the 3 usual conditions associated to them but in addition I need to be able to colour individual cells if they contain certain phrases or parts of phrases like "BP" or "Current"
i am trying to highlight the cells red in the b column if a3=d3 (if names match) and if b3<e3 (only if name is "a" should e3 be used to compare with b3). hope this makes sense. i've attached a sample worksheet.
i've tried =if(b3<e3, (vlookup(a3,d3:e33,1,false),true)...but does not work correctly. i need the average weight to remain constant according to the name when comparing, but if i drag the formula down to other cells, the average weight does not correspond to the name.
What i want to do is highlight all row instances where that row column10 has the text "Roller" . All i can see is the forumular =$J1="Roller" ive tryed to select just the single cell J and tryed the whole row and a range. Though i get a error message about =-+ quotation ect.
I am using conditional formatting to highlight all cells where the value <> 0.00. It's working for 98.9% of the records, but for some reason, about 5 of the records with 0.00 are being highlighted for some reason. I've checked the field formats and they're the same as the other numbers.
I have in a range B10:B110 formulae that returns a number. When I try and use CF to highlight the lowest number, it does not trigger. Is it not possible to have both a formula and CF in the same cell, that triggers the CF.
The Problem: There is data in a step chart from left to right. On a separate step chart, Conditional formatting is set to lookup values from the first step chart and highlight non empty cells in the row. The formatting should only format the first non empty cell from left to right in the row. After formatting the first non zero value in the time line the formatting should cease. Note: the conditional formatting value and the value of the cell being formatted are not the same in either value or time but are related. The formatting is to illustrate the relation
Current Formatting formula:
Syntax for Vlookup(Lookup_Value,Table_array,Column_index_num,Range_Lookup)
I have a spreadsheet where I have a column of dates and I want conditional formatting to highlight the cell red if the date is less than or equal to today but if the cell is blank to do nothing.
At the moment I have the following formatting applied using the "format only cells that contain" option I have cell value less than or equal to =TODAY() except that obviously highlights every cell red that doesn't contain a date. Is there another conditional format I can apply in addition to this that will not highlight the blank cells ?
I have a spreadsheet that keeps track of staff training. in colum A is the date they completed the training. this training expires in 5 years time. i would like the cell to highlight red when the date has expired. and when i enter the new date in 5 yrs time the cell to return to no fill color.
I have a list of items which are supplied by 3 persons and these items have expiry date. I want the Conditional Formatting to highlight 2 days before its expiry date. I have managed to set only for dave, how do I set for the other two persons? FYI, each item is only supplied by one person.
I have a spreadsheet showing names, quality percentages and times taken to answer a call in 3 columns. I would like to highlight the cells that fall within the top 20% of those shown (e.g. if there are 100 quality percentages I want to highlight the top 20 not those over 80%) also the same with call length.
I have a column of numbers and times (mins and secs) and what would like to do is set a conditional format so that the cell turns a colour when the number of any cell is within the highest 20% and the other column turns a different colour when the time is within the lowest 20%.
I have 3 rows with numbers across several columns, each cell holding one number only. For example:
R1: 1101 - 1102 - 1103 - 1104 - etc. R2: 2101 - 2102 - 2103 - 2104 - etc. R3: 3101 - 3102 - 3103 - 3104 - etc.
A little further down I am having a list where the end user will write down the exact same number. Once the same number has been written into the list, I would like the number shown in the top rows (row 1 to 3) to be highlighted in green, basically telling the user that the number has been entered into the list below and is ok now.
I am trying to use condtional formatting to highlight a row in a table if the order number is NOT on another table, on a different sheet. Example: Order Number 1001 is in my table on Sheet4, Once the order has been filled is comes off my "Pending Orders" table on Sheet1, which is based on a data connection, so it updates once the connection is refreshed. I would like the row with order number 1001 in my table on Sheet4 to be highlighted letting me know it can now be removed, since I have to manually manage this table. I am using Excel 2010.
I need a macro that will highlight a row based on a cell criteria. I have used conditional formatting but there is a lot to format and has dramatically slowed the sheet down. However, I know nothing about macros/vbas.
E.g. If it states JI sent then I want the whole row to be highlighted light green.
App form needed = peach Waiting list = light blue Cancelled = red font strikethrough DNA = purple font strikethrough.
Also - it could well be that in the row it has App form received, JI Sent and DNA all in 1 go. So ideally I would want that row to be highlighted light green with purple font strikethrough.
Booking Status JI Status Date JI Sent Attendance Cancellation date Chargable / non chargable Cancellations Chargeable / non chargeable DNA Date taken Time taken Event Title Start Date Time
I need a conditional formatting formula that will highlight the second instance of a combination of values from two columns.
For example, Column A is a person's name and Column B is a drop down with 3 options (Street Address, Phone Number, and Email Address). If Row 2 says John Smith (Column A) and Street Address (Column B) and Row 6 also says John Smith (Column A) and Street Address (Column B), what conditional formatting formula would I use to highlight Row 6 as duplicate information?
I have a spreadsheet and I want to color particular cells in a column with a new color - i.e. any new changes need to be highlighted. I know there's a way to do tracking changes in excel, but it just sticks a little flag almost invisibly in the corner of the cell. I want to be able to bring the spreadsheet back to our administrator and say hey the stuff in red is new.
On a related note - I am working on this massive spreadsheet that is a .csv but I am saving it as an exel spreadsheet - is that ok? I am assuming that if I save it as a csv, it will return to the original formatting just without the colors, filters, etc changes I made - which is fine because I think somehow the .csv file will be uploaded to the system and no further changes need to be made.
I found out the hard way when you have a .csv file and make changes and then save it, you lose all the fun row/column size adjustments, color, etc - but I figure in the meantime I'll work on it as a excel spreadsheet and then return it to it's natural .csv file status.
I just cannot think through this conditional formatting statement.
The conditions: -- If the current (todays) date is 8 working days after the created date, then highlight in orange -- If the current (todays) date is 10 working days after the created date, then highlight in red
On other words... -- The dates that will get highlighted in red are overdue for processing -- The dates that become orange are approaching the overdue time -- Any dates that are less than 8 working days are NOT highlighted at all