highlight conditional

Hi, I have shift calendar template from this site I am a bit puzzled to explain so I will use the following image below: Based the image, I have schedule like this: Then if I see highlight in the calendar, I get wrong highlight (I marked with a red horizontal line). The range in red...

Hi all, To give you an overview of what i'm trying to achieve. We have 280k of registered users (last 2 years regs) and we have a subset of 116k users that have opted into our marketing etc (this covers a longer time period). We have a massive service change and have a desire to tailor our...

Say,I have 2 tables...Tables are related... 1 3 5 7 8 8 9 10 11 12 13 14 & 2 3 5 5 1 1 1 1 3 4 4 4 I have highlighted top 5 values in first table using conditional formatting rules.Now I want to highlight cells in the second table based on first table...Assume 11 12 13 14 7...

Hi, <tbody> I need to highlight duplicates in column A, but only if column B is equal to 10. <tbody> 68923 10 68923 20 68923 30 68924 10 68924 20 68925 10 68926 10 68927 10 68928 10 68923 </tbody> In the example above, what I want it to do is, as...

Hi all, I need some help with a monthly project scheduler my boss has asked me to create. Basically it shows all of our current jobs for the month, the employees and equipment allocated to each job and the start and end dates for each job. I need help with the formatting to highlight when...

Hey, Overview and goal: I'm looking for something that will help with commission approvals. Rather than going through and highlighting the cell that is being paid, I'd like it to automatically do that depending on the values in 2 cells. I'd like to highlight the lowest cell in a column (only 2...

Hi I'm stuck with this one, the below is an example of what I'm trying to achieve. I need to highlight the rows depending on the values on D and F. I've done =NOT(ISBLANK($P1)) in conditional formatting to highlight the rows when a date is entered in column D but I can't figure out how to...

I inherited an Excel 2010 workbook that is utilized to import in another excel data feed that is extracted from online source daily. Once imported this .xlsm workbook does several things, custom columns, several sorts, conditional formatting, etc. It currently highlights all rows that have a...

Fellow Forum Members, I have a lot of cells containing numbers and with dark colored highlights applied that makes the numbers hard to read. I also have other cells with colors like Yellow that is easy to read the black colored fonts. What conditional formula can I use to change Black Font...

I would like to highlight column B1:AF31 using conditional formatting. If not conditional formatting- how to highlight column B1:AF31 based on weekdays. (I am currently working on Jan01 to Jan31). Thank much.

<!--[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/>...

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 need entire row to be highlighted if the word "apple" is present inside any cell no matter what column. How? KIND REGARDS

In columns F and H of a spreadsheet I have various currencies (e.g. USD, EUR, CHF). Column F always contains a currency, but column H does not have to and so is sometimes blank. I need a formula that will highlight cells which have the same currency in a given row. Thus if there is only a...