formating

  1. L

    Conditional Formatting Not Applying

    I have configured excel conditional formating as per in the picture and the cells are not highlighting as they should be. In this formating it should highlight four cells with red. I then put " between the numbers and you can see in the 2nd picture cells are highlighting but the wrong...
  2. R

    Mirror Sheet & formating to another sheet

    I'm trying to mirror 3 Columns (staff names, staff number, position) from sheet1 to sheet2. Sheet 2 will have the 3 mirrored columns plus additional collums that need to relate to the 3 mirrored columns (such as pay, Birthdays ect) I need to be able add and delete rows on sheet1 and for this to...
  3. S

    conditional formating

    Please your help will be appreciated I dont know if it is possible but I want to highlight (conditional formatting) a column B14:B128 depending on the text values of another column D14:D128 where some criteria met on a specific cell D134 that contains text and is like a dynamic cell i am going...
  4. Z

    problem in excel-PLEASE it very important

    Respected, I have a big file of 400MB+ which has lot of functions. Just 15 days ago I was able to copy a line of 50+functions to another place in just 2-3 seconds but now it takes 2-3 minutes. I have tried every thing like (1)completely writing new formulas so that there might be some routine...
  5. C

    Excel Conditional Formating: Earnings above and over

    Hi can some one help be with a formula for conditional formating. I have a database of 12 months earnings (A - L Coloumn) i want a formula for if it is above the average and another when it is below. I have used the conditional above formula but it tends to hightlight all even if they are...
  6. A

    changing font size

    how to change font size in conditional formating
  7. Y

    Look up value in a table, Return corresponding header

    https://docs.google.com/spreadsheets/d/1Z9N1Csn07SnHt2wqI4W0mNoC86BowudvMW37PBlFvXo/edit?usp=sharingI have an issue here i need to look up a value in a table of information and return the header title of the column that the value is located in.Is there a formula to do this of should i change the...
  8. V

    VBA formating excel change for example: 18D00132 to 1.8E+133

    Hello Friends, I put to vba this: Sub BehProgramu() test = IsNumeric(786) test = IsNumeric("Tech on the Net") test = IsNumeric("234") test = IsNumeric(18D00132) End Sub And when I click enter the last row is transfored to expon. format, why is excel doing this ? Sub BehProgramu() test =...
  9. V

    VBA formating excel change for example: 18D00132 to 1.8E+133

    Hello Friends, I put to vba this: Sub BehProgramu() test = IsNumeric(786) test = IsNumeric("Tech on the Net") test = IsNumeric("234") test = IsNumeric(18D00132) End Sub And when I click enter the last row is transfored to expon. format, why is excel doing this ? Sub BehProgramu() test =...
  10. D

    Removing Break Lines in Cell

    Hello, I have a problem. I'm scrapping information from internet but when I place this info into cell It has a lot of break lines <tbody> " MLS Number Category Status Status Date Price 7068423 RES Temporarily Off Market 11/14/17 $150,000 6735873 RES...
  11. S

    Conditionnal formating in VBA

    Hi! I've a conditionnal formatting formula in EXCEL, I'd like to use macro to do so. Thanks. =SOMMEPROD(($C$5>=INDIRECT("Leave[departure]"))*($C$5<=INDIRECT("Leave[return]"))*($B8=INDIRECT("Leave[workers]"))) applied on =$C$8:$G$14 I'd like to do it on the table below with colour... Thanks...
  12. V

    conditional formatting..

    In Col B, 10 21 35 15 50 16 I want to highlight top 3 in different color, using Cond Formating..how do that?
  13. F

    VBA that insert new Line, Merge & Center, Change Background, Group, and....

    Hi Everyone, I have a very simple but time consuming process when working on some of my Excel Worksheets. I have been browsing here to see if there is someone with similar problem, but so far not found any. During my work I have several Formatting things I do, over and over and over again, but...
  14. K

    Same conditional formatting if same value

    Hi, Is there a way to get some kind of dynamic conditional formating: if A1 = B1, then A1 formating =B1 formating (font and text color). I thought of a macro on a change value event but I miss the "undo" function. Any idea? Thanks in advance
  15. B

    Conditional formating with an OR statement

    Windows 10, Excel 2010: How do I conditionally format the range A1:A100 to format for the cell value of "UNK", or "Unk" or "unk" using the OR statement? =OR("UNK","Unk","unk") does not work.
  16. L

    Custom Chart Data Lables format from % / # / h:mm:ss

    Hi all, I have a dynamic dashboard mini chart built that populates from a drop down box used to select some data that's reported in months. The data set has different UOM - some are in % some are numbers and others in minutes. Example below: <tbody> Jan-17 Feb-17 Mar-17 Eggs 17% 19% 20%...
  17. A

    How to list multiple, repeating times in a column?

    Hi I need to make an Excel sheet to make an animal observation paper. The list requires to observe the animals every 30 seconds so the list would look something like: 8:25 am 8:25 am 8:26 am 8:26 am 8:27 am 8:27 am etc... Is there a shortcut on how to make these times without having to...
  18. C

    Format table with variable number of entries

    Hi everyone, I'm trying to get a file formated automatically. This file is extracted from another program every week or so. In the image below, you can see an example of what I want to achieve. At the top, you see how the data is initially formated, and below how I want it to be. I've created a...
  19. J

    WEB Query Problem

    Hi guys, I'm using a web query to take some information from a file HTML file I have, but I'm having some troubles with formating things. In "P" column I take scientif number and Excel erase the first "00", there are any way to change this? Here is my HTML code...
  20. B

    Conditional Formatting with Several Conditions

    Good Morning, How can you create conditional formatting with several conditions? For example.. <colgroup><col span="7"></colgroup><tbody> GRADE ON 200 MESH </tbody> 20EXT24 15 20EXT24 32 ULD 14 ULD 24 I am...

Some videos you may like

This Week's Hot Topics

Top