formatting a cell

Hey, im looking for a way to set cell color based on another cell color. I got 2 sheets and i use cell references from one sheet to the other. I want the cells in sheet1 to be the same color (filled) as the cell references in the other sheet. my cell references is pointed at the A row. So i...

Hi guys, Id like to have the conditional formatting setup in cell G6 so that it does the following: 1. When cell G6 is below a cell value of 18 cell G6 has a green fill. 2. When cell G6 is a blank cell G6 it has no fill. 3. When cell G6 is above a cell value of 18 cell G6 has a red fill. 4...

Yeah, I'm obsessive, but..., OK, I have [<1000]#;[<1000000]#.##,"K";#.##,,"M" Which works great for positive numbers, now how about negative numbers as well (in RED, with a minus sign? Thank you

Hi all, I am trying to use conditional formatting / VBA / whatever it may be, to match the destination output formatting with the source formatting. My lists of data vary in length and formatting. When I input a value into X1 my lists of data appear but I want the formatting to move with the...

Hi everyone! I hope you are well. Is there a way to append text from a TextBox on a UserForm to a cell without losing the cell text formatting? Please see sample workbook attached :) TextBoxSample

Hi. I must be missing something really obvious here. I have a non-standard date in cell A1 (formatted as "General") that looks like this: Apr 10, 1839. I have about a hundred rows and tried to sort by "Date", but it did not work. I figured it was because they were formatted as "General"...

Is there a way to copy and paste formatting from a range of cells on one sheet in a workbook to the same cells on multiple other sheets at the same time? I have a timekeeping workbook where I have 52 tabs where each tab is a week for tracking hours worked. I need to go through and adjust...

Hi all, I am creating a spreadsheet to track job progress. Each job has upto 8 different tasks. For each task I have 3 columns in a table named "Required", "Booked" and "complete" Required will a yes/no from drop down box booked and received will contain dates I then have 8 columns in the...

In Google Sheets I have a column that checks another two column's and calculates the difference. I already have it conditionally formatting to be green or red depending on the difference being less than or equal to 0, and greater than 0 respectively, but I specifically want to have it display...

I have a document where I want to copy the cell color from 12 individual cells on one sheet to 12 other cells on the same sheet, in addition to 12 cells on a separate sheet. One set of 12 cells needs to be the master cells or the original ones that get referenced to copy to other cells. Is...

Hello, I am trying to make a checklist which I have set up by having each task in its own cell with another cell next to it to act as a checkbox. I want to make the background color of the task cell and the checkbox cell change to green whenever I place an "X" in the checkbox cell. It was very...

Hello, i am trying to apply a currency symbol dynamically using formula rather then VBA. I don’t want to use cell formatting as I am reading these values in other sheets and need to make sure it is clear what currency each number is in. in order to do some sums on the numbers, I am using the...

I've got the following formula: = G3 < H3 Works fine but I need to do a similar conditional formatting formula for several other rows and the reference rows will be different each time. For example, K3 < L3 as the next one. Is there a way I can go all the columns I need in a single...

Hello, I have an index/match formula in a cell on a sheet named "Overview by Specialty". The information is being pulled from a sheet named "Consolidated". I am trying to figure out how to keep the formatting from the consolidated tab. Conditional formatting would require an infinite number of...

Hello! How do I delete boxes that are input into a cell?

I'm trying to remove excessive cell styles with a workbook but every macro I've tried times-out. Does anyone have a macro to remove and reset cell styles to default quickly?

I have 2 columns, Column A has a regularly formatted first name. Calibri 11. It is also a look up formula from another sheet. Column B is Surname which is also a lookup formula from another sheet but I have used the Upper function on it to make it all upper case and also bolded the column. I...

Hello, New to this forum, I thank you for your help in advance. I need dependent cells to follow the decimal formatting of a one parent cell. I've done this with format painter but my parent cell decimal requirements changes from time to time and I need the dependent cells to adjust and...

Hello all, 1st post here so I will try and be as descriptive as possible. Appreciate any help! I'm using Excel 2018 and I'm trying to get conditional formatting to show an arrow pointing up in green and an arrow pointing down in red. I do not want to fill the cell with color, I only want the...

Hi all, I have about 30 spreadsheets I have to process every week. For each cell in these spreadsheet that contain a 0, I have to manually change the format to currency without the $ sign. If a cell has a value other than o, I need to leave it in the current format. As you can imagine, doing...