conditional formaatting

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

I have a large Excel table with a Date column. The values in Date column range from 6/1/2003 to today. How do I add conditional formatting that will surround a table row with a huge red border (or a highlight in yellow) if the current value of Date is not exactly one day greater than the...

Hi, I'm trying to conditional format all values that are less than those in 5000 So if location 5000 has 8 units and locations 4000-9300 have less then highlight those locations (that don't have 0) Thanks

Hi all, I have been recommended this site by a friend as I am having issues with a spreadsheet I have created and so I would be very grateful if any of you could help me get to where I need to be. So, I have 3 worksheets on my document all of which needs dates input into them. I have a 4th...

Hi everyone! I haven't posted any issues for a while, but this one really got me or I'm just getting older :) Basically I would like to format the cells based on the result of a lookup value from another table. I managed to apply the index match formula to return the value, that needs to be...

In the attached workbook, i have to compare the *COMPETITOR* Worksheet with the *PLAN* Worksheet. The comparison is to be done between Plans Premium, Plan_Amount and Item 1 Price in both the sheets and conditionally format the Competitor worksheets entry as blue and red depending on the values(...