formatted

Been messing around with codes and just can't figure this out. <tbody> A B C D 1 Player 1 11 22 33 2 Player 2 44 55 66 3 Player 3 77 88 99 </tbody> If Player 1 is not blank; and Player 2 and 3 is blank. I need 11 to be formatted. If Player 1, and 2 is not blank; and player 3 is...

I have some work sheets, which I maintain, that a couple of my colleagues also use and they copy some of their data into my worksheets. My work sheets are formatted and have some formulas in them and when they copy data into them, they use the paste function, not the paste values functions...

Hi, If, for example, the value in cell B1 contains the word ''Done'' I want the word in cell A1 to be formatted. How should I do this? Thanks in advance.

Excel experts, I have checked other posts related to extracting text, but I am not able to understand how I can implement that to my needs. In column A, I have 2,000 rows of the text string that resembles the following: "07/16 07/14 1234 WM SUPERCENTER #1234 HOUSTON TX $5.99" A) The first...

Hey, I've got a bunch of data from a BI source, but they havent provided the currency. The values are formatted in the correct currency, so i want to write a formula in another cell that will tell me what currency each line is in. Any idea how i can do this? I'm sure i've done this before but...

Hi, I am fairly new to formulas so hoping someone can help me with the following: On my invoicing sheet I have the invoice amount in column D formatted like this: £1202.02 (I manually enter this) In column K I have notes which are formatted like this: <style type="text/css"><!--td...

Hello I need Help making a spreadsheet where my cell rows from (J30:T30) are conditional Formatted with Higlight cell rules and I want a cell result at the end to show in numbers all of the background highlighted with the condition formatting results. Can some one help me pleaseeeeeee...

Hi, I have IDs in Column A stored as Text (data is both numbers and text). To get unique IDs, I used an advanced filter and the results are in Column D. Problem is that the results show duplicates. For example, 130 shows twice. One has the error message - number stored as text- on the...

I have a dilemma that I can't resolve and can find no relevant examples. I have two tables with Class mnemonics (pharmacologic/therapeutic classifications) listed in the general format - 00:00.00. when I download a report containing this information some are formatted as custom but with...

I was working on a sheet to compare actual vs expected times (0-60 minutes) when I ran into a problem with negative time differences. If the difference between the expected and actual items was positive (non-negative), no problem, but if it was negative, the cell, which was formatted as...

Hello, I'm looking for a formula to color cells based on weekends and holidays. In cells L2:AP2 are the days of the month. Using the conditional formatting rules I used the following formula "=WEEKDAY(L$2:AP$2,2)>5" to determine the cells to be formatted. In addition to weekends I would like to...

Hi, i have a column which is formatted to populate an overdue when a date is less then today. When I drag the formate down it populates overdue as there is no date currently. How to i I keep the formate however when the source cell is blank the formatted blank remains blank too? sam

I have a table with a dynamic number of rows. The cells are formatted to Accounting in column E & F. However in column F, a handful of numbers appear as text and not as accounting numbers. Is there a code that goes down column F, and where the cell is a text cell, then firstly convert this to a...

Hi there, This is probably a really basic fix but it from a spreadsheet my boss created so I want to be sure before I mess with it. We are creating an order sheet for garments. First step: We have headcounts per item, we then add a 30% redundancy to calculate the minimum amount to order...

Hi forum, I have this piece of code which creates a dynamic array, redims it, then assigns a range of cells on a worksheet into it. The data that I populate into the array are ID's of people, that are formatted as TEXT with leading 0's. (e.g. "000123123", "000111223", "000199382".....)...

I am trying to do a simple timesheet calculating hours worked: 10:35a-5:15p Formula: b1-a1 A1 and B1 are formatted as time with hours, minutes C1 is formatted as time in custom: h:mm Results are- #Value !

I have three fields in my Table. Field 1 is today's date formatted as yyyymmdd Field 2 is Case - Auto NUmber formatted 000 Field 3 is Case # - Calculated field - [today's date] & "-" & [case] I am trying to create a case number that would result in the date coming out as 20170530 and the number...

Hi, My staff enter a numeric value into a cell. This value needs to start with 0 but some staff keep forgetting and just enter say 12345 as opposed to 012345 Can you advise how this is formatted so next time a value without the 0 is entered then leaving the cell etc will add it. Thanks

We are on Office 365 and this has only started happening recently (last couple of months) so I don't know if it's due to a Microsoft update. Excel keeps formatting dollar amounts in regular data ranges and Pivot Tables as dates. See screenshots from this workbook, which is years old and has...

I have a spreadsheet to keep track of lab equipment. I have the Serial Number column set to find duplicates and highlight them with a red background. The entire column has the cells formatted as TEXT. I just came across a problem with two separate items that show as duplicates. For the first...