conditional formaatting

I am having trouble adding conditional formatting to one cell. I have developed an attendance Grid. This is how we want it to function: When column C "Accumulated points" reaches 20, highlight column C Yellow. Column H and J or manual fields. When column C reaches column H's number + 4...

Hello, I'm trying to create a professional looking Dashboard that a person can look at and know if everything on the document has been filled out. I was thinking of using the stoplight feature, but I cannot figure out how to make it look for words instead. An example would be that on sheet 1...

Hello. I want to format cell in which is text "Martin" (C10) and also two cells on the left of the cell with "Martin" (A10:B10). Expectation: With formula =C2="Martin" I am able to format only 2nd cell to the right of cell containing "Martin". When I change formula to =A2="Martin" then...

Hi all, I think I am overthinking this one and need some help please. I am writing a conditional formatting formula so that cell B2 will highlight "purple" if cell i2 is blank and cell j2 7 days has passed since the date shown I have input the below formula and it works if cell I2 is...

Hello All! I have my Table (Table13) I want the respective row to highlight when an "x" is in column D ("Reviewed (x)") This is the formula I'm using in conditional formatting: =$D$5="x" | applied to =$D$5:$I$5 which does of course work, however the problem I'm having is because it is a fixed...

Hello everyone, I'm facing a weird case while doing some conditional formatting on my report. The condition is: Cell turn Red if value lower equal to -0.1 and higher equal to 0.1 Cell turn Yellow if value between -0.1 and -0.05; 0.1 and 0.05 Above condition applies to Cell D4 & E4, please see...

Hello I have the below code which moves a row of data to another sheet based on a value selected from a list. When the list item is selected, I'd like the row to be moved to the "LTS" sheet with all conditional formatting removed. Is this possible? Private Sub Worksheet_Change(ByVal Target...

Hi all, I'm struggling with formatting a pivot table based on some conditions. My Pivot table has Countries as columns and Date as Rows (will attach a screenshot). I need to fill the cells with Red if Blank, however for some of the countries (i.e Egypt,Ethiopia) if Blank need to fill with...

I've been wraping my head around this one for couple of days, might be that I am just looking at this in a wrong way. Here is my problem: - i have data blocks that are divided by empty cells in columns G and H. Column G has to show MAX value in green and Column H needs to show LOWEST value in...

Is it possible to configure conditional formatting to highlight cell if the data comes from a different cell. My example would be I have a seperate sheet that houses my input data and then it is this that feeds information to another. So if my inputs sheet looks like the attached can I have...

I'm trying to write a VBA CODE example mentioned below. Help on the below-mentioned example A B C D SL NO PRODUCT MANUFACTURING DATE EXPIRY DATE 1 ABC 01-01-2021 01-01-2022 2 XYZ 29-03-2021 29-03-2022 3 CDA 04-05-2019 04-05-2020 4 TWC 23-03-2021 23-03-2021 I want my output as...

Hi there, First time poster here, any help someone can offer with my conditional formatting problem will go a long way! I have a worksheet with worksites listed in the Column A and the days in a year listed across Row 1. In a second worksheet I have the following data: Column A: Worksite...

Hey all, I hope I can get some help here. I have looked around for a solution and have gotten close but not there, it is a tricky one. This is the closest I have gotten: Send email based on date I have an excel spreadsheet stored on onedrive It has 4 sheets with employee details, 3 sheets...

Hi Guys, Columns B, C, D, and E contain a list look-up (Yes or No) Earlier today, you guys helped me that if column B and/ or E has "Yes", to return certain text (Thank you!) I placed the updated functionality in column F. Then I wanted the user to identify the scope of work based on the...

I am using formula in conditional formatting to highlight cells of date which is of lesser than 7 days of Today's date. =AND(E:E<TODAY(),E:E<(TODAY()-7)) I want a formula that it should highlight the color of dates which is of more than 7 days and and less than or equal to 10 days which will...

Dear All experts , Please forgive me for my bad English as i am not native English guy. I am assigned to carry on some work from my company and i was given a excel sheet which was probably made by my previous colleague , since i am not very familiar with VBA for excel so i am looking for help...

Hello everybody, I am currently managing a worksheet containing a stock overview, which looks like this: I have made two conditional formatting rules which assert under my "Antal" (meaning Quantity) column that if the number is below or equal to 0 the color should be red and if the color is...

Hi, I currently have some vba code that looks at column BM and if the cell is empty then it sets the interior colour to white for all cells in the row (from BM to BZ). If there is something in the cell in column BM then it changes everything in the above range to yellow. What I want to add to...

I want make color each materials last three or less than three value. Materials Name Value A 1 A 2 A 3 A 4 A 5 A 6 B 1 B 2 B 3 B 4 C 1 C 2 C 3 D 1 D 2 E 1 E 2 E 3 E 4 E 5 F 1 F 2 G 1 G 2 G 3 G 4 G 5

Hello, I am trying to figure out how to write an aging formula with conditional formatting for a column that will notify the user how long the report is open before they go to a different column and change the status of the report "closed". I am trying to add now extended if the report needs...