formatting

Morning all Using what I have learned, today I managed to copy a range of one sheet to a new sheet preserving formatting using the paste special method. This sheet is then copied to a new workbook that opens, saves and closes using the below code. This method although very simple does not seem...

Good afternoon everyone, I'm thinking this is an easy question but I'm having a brain fart and can't figure it out. Basically I have a spreadsheet where I need to have a red light whenever the percentage is less than -8% and a green light whenever the percentage is more than 8% and have no...

Hi, Im curious to find out how this is done? It's probably dead simpel but i can't seem to snatch it in google :) How do you add a line below the text in the cell with padding in the ends (as seen in A12-F12)? I've replicated with borders but the you lose the grey grid. Thanks! /Marten

In conditional formatting I would like to highlight the whole row when yes is entered into cell M2 then each row after that. Sorry cannot paste table into here Thank you for any assistance <colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>...

I am having trouble coming up with code that will scan the column headers, strings, and then apply the specific conditional formatting based on values in that column. The order of the columns can vary depending on how individuals pull the report. I want the formatting consistent despite the...

Hi I want to highlight "pass" in result column to different color but not only pass but student name that correspond to that pass For example, cell F2 = pass should be highlighted to different color and also Mary1 as well (like reverse lookup) I can use conditional formatting to highlight pass...

Hi I have no problem to copy conditional formatting from one cells to another in the same sheet using format painter tool. But I noticed I can not copy conditional formatting to different sheet? Is that by design? Thank you

Hello All, I am trying to retrieve the formatting of the cell that is Matched using the INDEX and MATCH functions and then apply that formatting exactly to a cell currently using this formula: =IF(D1="","",IF(INDEX('WORK ORDER DATABASE'!W7:W157,MATCH(CO19230COLP!D1,'WORK ORDER...

Can you do conditional formatting on a column based on last number in each cell. I need to highlight all cells that end with a 6 in a particular column. Thanks

Hi there, In a peice of VBA code I am a using Copy-Paste with xlValues as follows: Dim Sourcebook, Targetbook as Workbook Dim Sourcesheet, Targetsheet as Worksheet Dim Sourcerange, Targetrange as Range ........ Sourcebook.Sourcesheet.SourceRange.Copy...

I need to change the cell text format to RED if the value of the cell is changed (not formatting or just clicking in it). Additionall, when the cell is changed in a row, a column at the end needs to show the date last changed (mm/dd/yyyy) and name of computer that changedit. Is this...

Hi, I want to format the A column depending on the data in I J and K column so i could make 3 different Formatting rules =$I1="True" But what if i want to do I J and K in the same formatting rule? Sorry if its a bit unclear

Maybe it's because it's soo late and I'm here working on this but I can't figure this out. Help from the masters would be appreciated. I have a conditional formatting formula already setup and it works... <date(2019,8,2))) AND(($AZ10>0.249),($F10<date(2019,8,2))) <DATE(2019,8,2)))...

I have code for pasting data from CSV file to Worksheet. Everyhting works fine but I am facing some problems with current solution. Is there a way to paste data as it is without formatting? Now Excel is formatting for example -Name to =-Name so there #Name ? errors instead of Values. Also it...

Hello, I have applied conditional formatting to a range ofcells, for example A1 to D1 and the cells are colour coded based on the value. I am now struggling as the cells in A2 to D2 need to be formattedin the same colour, is there a way to Link the colour format ? SO effectively A1 and A2 would...

Hi, Possible to use conditional formatting to 'sum count' font colour? 1 2 The ans should be 2 'count'

Hi, My formula seem to be wrong. Can any one please help me check the formula. Appreciate in advance. Thank you. https://drive.google.com/drive/folders/1GONwJfx01v_XZeHrg3burkBavuF3ffIJ?usp=sharing

Hello, I have set conditional formatting in specific range. If is not empty then background color = green + outer borders. I sometimes use merged cells in this range and by merged cells is the borders unfortunately not complet. Is there any way how to solve it? thank you very much Miroslav

Hi all, If I have multiple columns that I'm identifing differences in, and what to highlight those differences. What conditional formatting formula could I use? Example: Columns A2 and B2 should be the same, but they are different values. I want to highlight both cells. This rule would be...