conditional formaatting

  1. M

    Conditional Formatting Won't Work If Cell Have Formula

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

    VBA Clear Conditional Format

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

    Conditional Formatting - Pivot Table

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

    Find MIN/MAX Value with conditional formatting in given block of DATA - then repeat

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

    Conditional Formatting

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

    VBA Expiry date with entire row Color highlight & new column with status

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

    Conditional formatting with multiple criteria

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

    VBA, Send email before expiry date of license and colour cell red

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

    Nested or formula combinations

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

    Conditional formatting for changing column color if between more than 7 days and less than 10 days

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

    Complete Rows Highlighted when there is specific data in cell with specific color & Latest Balance Get Auto Color

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

    Conditional formatting (extended? or vba code?) for entire row

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

    VBA - Using AND for conditonal formattiing

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

    About conditional formatting

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

    IF Formula for Aging Reports

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

    How do I add conditional formatting for a row in my table if the value in Date column is not one day greater than one row above?

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

    Conditional Formatting based on OH

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

    Product expiry date help

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

    Conditional formatting based on values in another table

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

    Color cells of a worksheet by comparing entries with other worksheet.

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back