formatting a cell

  1. B

    Value function error with £ currency

    Hello, i am trying to apply a currency symbol dynamically using formula rather then VBA. I don’t want to use cell formatting as I am reading these values in other sheets and need to make sure it is clear what currency each number is in. in order to do some sums on the numbers, I am using the...
  2. G

    Conditional Formatting Question

    I've got the following formula: = G3 < H3 Works fine but I need to do a similar conditional formatting formula for several other rows and the reference rows will be different each time. For example, K3 < L3 as the next one. Is there a way I can go all the columns I need in a single...
  3. K

    Keep Formatting through VBA with Index/Match

    Hello, I have an index/match formula in a cell on a sheet named "Overview by Specialty". The information is being pulled from a sheet named "Consolidated". I am trying to figure out how to keep the formatting from the consolidated tab. Conditional formatting would require an infinite number of...
  4. T

    Delete Boxes in cell?

    Hello! How do I delete boxes that are input into a cell?
  5. W

    Excessive Cell Styles (macro not working)

    I'm trying to remove excessive cell styles with a workbook but every macro I've tried times-out. Does anyone have a macro to remove and reset cell styles to default quickly?
  6. A

    Formatting 2 strings in cell in different ways

    I have 2 columns, Column A has a regularly formatted first name. Calibri 11. It is also a look up formula from another sheet. Column B is Surname which is also a lookup formula from another sheet but I have used the Upper function on it to make it all upper case and also bolded the column. I...
  7. R

    dependent cells to follow decimal formatting of parent cell

    Hello, New to this forum, I thank you for your help in advance. I need dependent cells to follow the decimal formatting of a one parent cell. I've done this with format painter but my parent cell decimal requirements changes from time to time and I need the dependent cells to adjust and...
  8. U

    Conditional Formatting won't allow font color changes but will allow fill color changes

    Hello all, 1st post here so I will try and be as descriptive as possible. Appreciate any help! I'm using Excel 2018 and I'm trying to get conditional formatting to show an arrow pointing up in green and an arrow pointing down in red. I do not want to fill the cell with color, I only want the...
  9. O

    Examine and change format for each cell containing zero

    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...
  10. E

    Track formula change?

    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...
  11. H

    VLOOKUP keeps returning N/A Value

    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...
  12. F

    Conditional formatting cells based on another 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...
  13. D

    Having Troubles Formatting Cells to Delete After 365 Days

    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...
  14. B

    Formatting Cells to show Ft and Inch

    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")
  15. K

    Cell formatting problem

    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...
  16. J

    Convert numbers to date

    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
  17. L

    Replace ";" with CTRL+OPT+ENTER to enter notes on a new line in the same cell

    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...
  18. D

    cell location is locked cannot format it

    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...
  19. C

    Microsoft Word Mail Merge of cell formats

    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...
  20. MrManBoy

    Conditional Formatting

    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...

Some videos you may like

This Week's Hot Topics