turn

I hope I am able to explain what I am looking to do.... I would like to use conditional Formatting in a table where there is a value in cell E18 and a value in D18. I would like the value in E18 to turn red if the value in D18 is 3% or more than the value in E18. If the value in D18 is not 3%...

Hi Everyone, I'm sure this is a basic question, so please excuse my ignorance. I am trying to format the fill colour of a cell based on the value in a different Cell. So for instance if Cell A1 will have a range of values between 1 and 15, I want cell B1 to turn green if the value in cell A1...

Hi all,<o:p></o:p> <o:p> </o:p> I am a novice at excel and not sure if it’s possible formy idea to work.<o:p></o:p> <o:p> </o:p> I want to create a sheet which tells me the total numberof staff I have on duty during the day. With times every half hour from 0700 to2230. <o:p></o:p> When I put...

Hi- I am using Excel 2016 and it is doing something weird on me when I enter text into a cell.. It is underlining the entire row/ column.. I don't remember changing any formatting options.. how do I turn it off? It does go away if I save or click on another tab and come back to the first one..

Hi, I've currently got a load of timestamps in column J, generated by pressing a button. I wondered if anyone would be able to tell me how to get cell G10 to turn green if 3 or more of the timestamps are in the same day? Thanks!

I need a not equals formula for a cell. if cell A does not equal the sum of cell B and cell C. Cell A will turn red. any help would be great thanks

I am looking for a way to remove duplicates from a column. I know how to do it from the end of column up, but I need the first instant of the value to stay. Also I need the code to stop once it hits an empty cell. Column is segmented into different section spit by empty cell. I do not want to...

Firstly thanks for taking the time to read. I need assistance with a conditional formatting issue in that in Column AD I have a two decimal point number which I need to turn shaded yellow if the number is greater than 8 but less than 12 and if column AI has the text Non Member. Also to turn...

What i need to just a simple way to get a group of cells to copy into my body of the email. I have tried this: .Subject = "TURN UP " & Range("B15") .HTMLBody = Range("A15..B21") And this: .Subject = "TURN UP " & Range("B15") .HTMLBody = Range("TURNUP") But both...

Hi, I have the current VBA code below which I would like to turn into a loop: Dim NoYrs As Long 'number of years Dim LRbf As Long 'last row NoYrs = Sheets("Lists").Range("E655536").End(xlUp).Row - 1 LRbf = Sheets("BF").Range("A655536").End(xlUp).Row ' Get First batch...

Hi, Is there a way to copy data from SAP to excel using SAP? Currently Im doing it manually by copying the data to excel then back to SAP and turn to next page copy again the data, paste and back to SAP then turn to next page and again and again.. Thanks,

Hi Everyone, The other day excel started adding horizontal lines to the border across the entire row of any cell that i input data. The top line is a normal border, the bottom line is a thicker border. I thought it might have something to do with tracking changes, but I have tried to tinker...

I am looking for some options. If I were to Type in the characters APP in a specific cell such as L719 in column L I need the cells in that row from say A719:N719 to turn Green or If the characters were RFC I need those cells to turn Red. Thanks for any help.

I've got a resource-intensive file with thousands of formulas, VBA code, and which pulls in real-time stock market data for hundreds of symbols via DDE. I need to optimize for speed/performance wherever I can. In some of the columns, every cell has the dark green 'error' flag indicating an...

I am trying to make an excel sheet turn a hole row red when a value in the L column is before the current date, The first code succeeds in only turning the cell in the column red. Additionally, in the k column cell (second code) if the date is less than the L column date I need it to turn the...

Hi All, I want to calculate Turn Around time and SLA for making Tracker. So required VBA Code for this, so please help me. Below is the Details: <tbody> Shift Start Time 08:00 **** End time 17:00 </tbody> <tbody> Worktype TAT Start Time Turn Around Time Completed Time SLA ABC 2 Hours...