formatting a cell

Hi all, I have about 30 spreadsheets I have to process every week. For each cell in these spreadsheet that contain a 0, I have to manually change the format to currency without the $ sign. If a cell has a value other than o, I need to leave it in the current format. As you can imagine, doing...

I am racking my brain trying to figure out how to highlight the cell if it's formula has changed. For example, the formula in the cell is: =IFERROR(SUM(K5,L5)*VLOOKUP($G5,OH,2,FALSE),0) if a user changes the cell's formula to be something like: =IFERROR((K5)*VLOOKUP($G5,OH,2,FALSE),0) ,I'd...

Hi, I am currently trying to sync up two sets of data via a VLOOKUP for 15 minute data discharge data and hourly precipitation data using dates and times e.g - 30/06/2007 16:00:00. When I do my VLOOKUP, the results returned are N/A. However, when I click into and open the date and time cell...

Hi all, I have a cell in one tab (we will call tab 1) with a formula in it that presents the data like this: 232 +126.9%. The formula to get this data pulls data from other tabs within the sheet and separates a value and calculates the percentage increase from last year. I need to conditional...

I've a column D (which I plan to hide later) either filled with a date or left blank. Then I want to have column E either display the date from Column D if the date is within one year or display nothing if the date is over one year old. The format I have right now in D2 is...

I was wondering if someone knew a formula or how to format cells to show foot and inch as a reference? Example: 549.75 (45'9 3/4")

Hi, I have one cell in my spreadsheet "1" that doesn't react to formatting. In the spreadsheet "1" there are many cells that have links to another spreadsheet "2" and if the values in that spreadsheet "2" are zero then by using cell formatting in the spreadsheet "1" instead of values "0" there...

Hello all- I have a long row of dates formatted as 'general' that looks like this: <tbody> 20170329 </tbody> How can I fix it to read: 03/29/2017 Thank you! Julie

I don't believe this can be done with the "Replace All" feature of Excel. Example: I want to take the text in this cell below: <tbody> the dog ran; the cat slept; I have two dogs - they're both poodles </tbody> And run a VBA code (unless there is an easier way) to space the sentences on...

Hi Everyone, Someone got into my spreadsheet and locked a cell so I cannot format it. How can I find out how they did it and how can I unlock it? cell G1 has the date January 1,2017 in cell G2 I have (=G1) and custom formatted to "d" to show the day only but it shows January 1,2017. No...

Hello, I have had 2 instances recently where I have struggled with merging excel into a mail merge and the format did not merge correctly. In the first, I had a per diem automatically calculated, which generated a very long decimal point. I formatted it to 2 decimals, however when it...

Hi All, Problem/Headache: I am trying to apply some sort of conditional formatting based on a cell value however, I only want the formatting to affect the corresponding cell to left or right not the whole column. Not sure if that even made sense, sorry if it didn't. . Example: In B1 I have a...

I am creating a database of possible protein sequences for a research project that I am working on. I need a way to do this type of formatting for my sequences and cant figure out a way to be able to delete one letter from the right hand side with each new cell...

Hi all - this is my 1st post here. I'm trying to write a SIMPLE ERP system for our farm to track P & L. I'm currently stuck on this IF statement - Well not so much the IF statement itself - but how to format the cell after the if statement finishes it's action. Here is the IF Statement...

This thread is regarding how format a color on a cell in a map of a building I drew in excel. In my map, each square foot in the facility corresponded to a cell in excel. For instance, the spot right by a door in the building might be "FA 130," where FA indicates the column and "130"...

Hi again, Thank you to those heroes that helped me with my question earlier today, but I've got another one. I'm trying to get this macro to highlight ONLY the 2nd, 3rd, 4th etc instance of a duplicate. I've since reverted to the original formula, but adding in a For...Each counter didn't...

Hi All, I am trying to display leading zeros after a hyphen. for example 9999-"0"800. The zero inside the " " is the issue. I can't seem to find a format to get this zero to be displayed can someone please assist. Many thanks Harvey

I am having problems trying to convert my USD$ currency symbol over to BRL $R currency. I read through a few other threads but didn't see any solutions that could fix my problem. To address some of those earlier solutions: - Everything is right aligned, so not an alignment issue - Not being...

Hiya, I would like to create a traffic light (Red amber green) so that i can monitor for whether things are on track for a deadline for major projects. ie. I wish to be able to select a drop down that says 'Late' under for example 01/11/2013, but all i want is for the box to turn red. and the...

I'm trying convert cells with currency formatting that have an apostrophe before every number. Here's an example of what the information in the cells look like: '$450.00 When I double-click a cell, the apostrophe goes away. But there are thousands of rows and I don't have the time or patience...