fill

I have a block of cells A1:D4. I want to set the fill color of that block based on the value of cell F1, which should have the form #XXXXXX, where “X” is a hexadecimal digit. And as I change the values of cell F1 the fill colors change as well. Is this possible? I tried conditional formatting...

WITHOUT doing a VBA is there a way that a note/comment can auto fill the date and time as well as the person's name? Thank you :)

I have two number columns A and B. I want to highlight column A with either a GREEN fill or RED fill. If the value of A is greater than B*0.95 AND A is less than B*1.1 fill it GREEN. If the value of A is greater than or equal to B*1.1 OR A is less than or equal to B*0.95 fill it RED. Been...

Hi, Unsure best way to do this. Value in Range A1 If value is 12 then fill 1-12 starting at C1 Then if Range A1 is 6 Do nothing as 6 is already in the filled range Then if Range A1 changes to 21 Extend fill range to 21 Appreciate any help

First of all, thank you for taking the time to read this. To keep it simple, is there a simple code line(s) that allow me to fill down automatically one column, with the value from a specific cell (I3 here), until the end of data (variable number of rows)? I have 600 files and the number of...

Hi, I looking for a new vba code for these. In my workbook. I need to make B6 cell as mandatory or need to fill first before you can do other work in workbook. Also a message popup if they not fill the B6 FIRST. Meant after save and open if B6 are filled you can continue your work. Thank you

Hello, I have a column that is conditionaly formatted. Cells change there fill colour depending upon the value. My cells change to red if the value <-0.1. Then green appears when the value>0.1 I have used rules type "cells that contain". but at the moment empty cells fill green. How can this be...

Hello, I cant figure out how to do a "double search" in a column. Conditional formatting would be better but entering a formula along a row could do. Hopefully I can explain what I am tryin to do. I am trying to find duplicates within a column (F through S), then in the duplicate row see, if...

hello i have data in sheet1 begins range from a2:c10 and userform contains 3 textbox the column c contain values when i fill data in textbox3 and press enter i would show the message " avalible is 200 or 300 or500.etc if the entered number in textbo3 more than what in column c my...

Sheet1 is data Sheet2 is data with fill color Abit hard to use conditional Formatting as i have at least 411 data with fill color Is there anyway to do it?

I have a sheet where column A is the product and column B is the price. I have a separate sheet with the price list. Column A has a drop box to choose a product from the list in the price list sheet. I'd like to price to automatically fill in Column B based on the value in Column A. I can't...

Hi all, It sounds easy but couldn't find the solution in excel (preferably without macro's). I have two sheets. Sheet 1 contains a list. In sheet 2 I have to fill in the last column, based on the list in sheet 1 (preferably using a formula). First column is just 5 times A,B,C,D. In sheet 1...

My situation Brand new workbook All options checked/selected: a. Options>Advanced>"Enable fill handle and cell drag-and-drop" b. Options>Advanced>"Show quick analysis options on selection" c. Options>Advanced>"Enable AutoComplete on cells values" d. Options>Advanced>"Automatically flash fill" e...

Hi MrExcel, Hope you can help with the below, I've attempted to google but I'm struggling to find results. I'm trying to fill the total material used on the following two screenshots (there are about 40 total), the problem is if we require a SW 38x63 timber to be cut at for example 2m, the...

I am currently using Microsoft Office Professional Plus 201. Flash fill came along in 2013. Is ther a vba to do the things that flash fill does (both adding pattin and splitting out without concatenate and text to columns)? Thanks.

<tbody> Number Fill Address 1026 902 E. Fremont 902 E. Fremont 1063 871 Main Street 829 Main </tbody> 1263 Hello All, I need help. I'm looking for statement that will help me fill the middle Column. For Example, If the address ha a row number then fill it with the...

Hi all :) Very new "VBAer" :) I have Excel data as per below <tbody> A B C 1 Location Code Series Number Country 2 4000 1 Australia 3 4001 2 Australia 4 4002 Australia 5 4010 Australia </tbody> I require this result <tbody> A B C 1 Location Code Series Number Country 2...

I have a code for a button that creates a new column at theend of a table. After the new column is added, I would like to have theformulas from the previous table column to fill into the new column. The datain the table should be the only formulas filling to the right (table headersshould not...

Hey all, There’s something I was wanting to do with our QC checklist, and I’d like your help with it. Essentially the idea is to have the cells conditionally formatted so that If cell J15= Y the all the cells to the right (M15,V15,AE15,AJ15,AM15 and AP15) will have a red fill until it is no...

Hello all, I have searched and searched but I have not found a thread covering this particular problem. Historically, when I have double-clicked the lower right corner of a cell, it will automatically autofill the cells below and offer a fill handle option menu (Copy Cells, Fill Series, Fill...