formatted

Is there a way to match bar graph column color based on the conditionally formatted color of a cell? I'm not too familiar with macros, but I ran one that I found on here that was able to change the column color to the cell fill, but I haven't been able to find one that changes the column color...

I'm looking for the vba code to evaluate every cell from A49 to the last row and if there's a number formatted as text error, for any of the data, then popup a message that says "Bad Data" and end the program.

I have the following formula, but it is not working because column C from Database is also a formula. =VLOOKUP(D4522,'T:\Version 10\[Backlog Template for v.10.0.xlsx]Database'!$C:$S,17,0) For what its worth Column C in Database is formatted as number and needs to be retained that way.

Running Excel 2016 I have this formula in cell G8 which is working, =IF(F8="","",ABS(D8*(1-F8)-D8)) Cell F8 is percentage/% formatted Cell D8 is accounting formatted with a entered/fix $ value With this formula is there any way for cell G8 to ignore zero? Thank you for all who respond...

Hi I need some help please! I have 3 cells - A1 contains a value; B1 contains a value; and C1 is to be formatted with a RAG status colour. If(A1>B1) then C1 should be filled green If(A1=B1) then C1 should be filled amber If(A1 <B1) then C1 should be filled red

Hi and thanks in advance! I have one array with with many rows and Columns, populated using a Macro when I have to paste this array in a sheet. I get the Values OK, but the formatting of the pasted cells do not show the values the way I was expecting. I mean: say Sheets(1).Cells(5...

hello I'm trying to add cells in a row which have been previously formatted by colour when they contain a tick mark. I can add the cells by colour when they have not been formatted but I have cells which need to contain a check mark with no highlight and cells which contain a check mark with...

Hi I formatted a small table (please see the link below). I changed the color of some cells. Now when I start typing on other cell below the cells I format it, these cells will get the same formatting to? why is that? Thanks you https://drive.google.com/open?id=0B5qI7A3TfxK5WHNzbS1pT05GeU0

You guys helped me out last time and now at another sticking point. I'm looking to highlight excel columns for appointments that happen today and anytime in the next 7 days, but having some trouble. I tried: =$A2>=TODAY()+7 and it formatted all of the dates 7 days from today forward, leaving...

I have a cell with =Now() in it that is formatted like yyyy - so only the year is visible - and then, in another cell, I subtract 365 from the cell to get the number for last year - it is formatted the same - yyyy. I want the 2nd cell or another one, if necessary, to only contain the 4 digit...

Hello everyone, I need some help for VBA code to be able to un-lock/allow selection and editing of cells in range E3:CG106 on 5 different worksheets in my workbook only when those cells are conditionally formatted to green (color index = 14), the conditional formatting on these 5 sheets is...

Having trouble with a chart. The date is in hours format. So it'll say something like 3:02. However, it is not formatted in excel. If I look at format cells to see how it is formatted it just shows as regular number. Anyway when I go to make a line chart with the data, it does not even...

Hi Been given a spreadsheet where a column h is designated date o fburial and column I is designated year of Burial Cell i2 shows jan-10 the formulae bar shows 01/01/2017 is formatted Custom mmm-dd J2 is formatted General and has a value of 1862 I need to change it to show 10-jan-1862...

Hi I went to format Cell-->custom. I see different formats like #,##0 what does that format mean? how you interpret that format? also how can I know what kind of formatting applied on a cell? Lets say a cell formatted as %, how can I know this cell formatted as %. Thank you

The rows/cells that contain the date data that I need to reference are: Col A, rows 5-19 - A5 contains a custom formatted date that displays as 'W/c 7 September 2017' Col A, rows 20-23 - A20 contains a custom formatted date for the next week in the same format Col A, rows 24-30 - A24 contains a...

Hi, I have data in Cell A1 and A2, 4 and 8 respectively. In cell A3 I need to combine both values - I am using =(A1&A2). I want both values to be formatted as numbers and I want the second value (i.e. A2 to have red text - appear in red). Any help appreciated. Thanks - Mark.

I got a file from a coworker that had the data formatted as a table. I went to the Design tab and selected "Covert to Range" to make it just a regular worksheet. When I tried to do a vlookup (or any calculation for that matter) I realized it's all formatted as text. So for the columns I...

Hi, I have an big problem! When I want to read the time from an time formatted cell it instead of 07:45:00 it Excel reads it as 0,322..... This is the script I use: If Range("Z1") > "" Then ............... .............. .............. ............. I'm greateful for all help I can got! Thanks!