formating

Hi, I searched and tried these directions below. It only highlighted all blank cells in sheet. I want to highlight active row. I couldn't reply, so signed up, the couldn't find thread but I had copied info (below). Please help, so close i think. We are going to use a formula based...

I have data with different delivery dates in another sheet. I want to do conditional formating that makes the lead time light pink if it is 2weeks pass each delivery date. I think sumifs with conditional formating could work

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

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

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

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

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

how to change font size in conditional formating

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

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

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

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

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

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

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

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

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.

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

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

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