condition formatting

  1. C

    VBA Data Validation with Conditional Formatting

    Hope someone can please help. 1. The Conditional Formatting code below works on this one sheet with Sheet Protection Off. However, with Sheet Protection On, it generates "Run-time error1004: Application defined or object-defined error". Please see this video for details. Note that I neglected...
  2. E

    Highlight all cells in a row, that contain value in first column

    Hi! I'm having an issue that I can't seem to find an answer for. I have an Excel sheet with IDs in column A, and I need a conditional format/formula that will highlight all cells along that row that contain the ID in column A. Column A contains different IDs. For example: see the value in A2...
  3. K

    When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding

    When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding. i was follow this code but not working pleased help me : Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Me.Range("C8")) Is Nothing Then...
  4. P

    How to remove weekends on conditional formatting

    Good day everyone, In the photo below I have made this. Can you help me to not highlight the weekends with the format for plan and actual. and have its separate format. Hope someone can help me on this.
  5. M

    Conditional formatting

    Dears, I need a "conditional formatting" to get highlighted if all the information are matching in all 3 tables like in the sheet.
  6. Jyggalag

    Create macro to separate first name and last name in email and plug it into columns

    Dear all, I am currently working on a spreadsheet that looks like this, albeit the real one is much larger: I was wondering if there would be some way in which I could create a macro or some VBA code attached to a macro where, once i press it, it takes the e-mails from C2-C12 and takes the...
  7. K

    How to Auto calculate Amount on the basis of particular Text i.e. "Total" Instead of Whole Text

  8. K

    How to use multiple criteria using to conditional formatting ??? (Condition is cell value After Zero Highlight Cell in RED color ?

    * how to Apply Condition Formating in Particular Cells At a time, (Condition : IF then " Available Qty " <1 to Highlight Cell is RED color). * This condition Apply but Not properly Working , Pleased help to solve this query, I try to use Multiple criteria using this condition formatting.
  9. K

    We Need Only TEXT Contain, How to possible in Excel Formula ????

    All Number list is Same Len ,if Number After Single Space , We Need Only TEXT Contain ,How to possible in EXCEL formula .......
  10. Preccor

    Conditional Format -[H]:MM

    The formula used for the cell is: =IF((F9-G9)>0,F9-G9,TEXT(ABS(F9-G9),"-[H]:MM")) Cells F9 & G9 are blank therefore the result of the formula shows "-0:00". How do I conditionally format the cell containing the formula so that the returned value of the formula which is -0:00 - the font color...
  11. E

    Pop Up message when value is changed - dependent on other conditions

    My data starts in row 2. Column AA is validated for Y,N,N/A values only, column ABcontains N/A or a date, and column AD can contain N/A or a date. All columns will initially be ‘N/A’ but there is apossibility that this will change, is there any formula that will bring up apop-up message if AD...
  12. M

    Conditional format formula to format cell colour based on a percentage of the cell

    H Excellers, I have a formula based total in I3 In E3 I have a formula based total too. I need to conditional format the I3. Red if greater than or equal to 25% of E3, Amber 10% to 24% of E3, Green if 0% to 9%. I do not have the space to create a separate percentage column. Thank you in...
  13. M

    Making a cell blank whilst keeping the formula nad the conditional formating

    Hi. This is my first question sorry in advance. So I hae two clumns C and D, D is my expiry date column and C is my start date column. I have formated D to turn orage or red depending on the time left. I also have the formual =EDATE(C3,6). The problem s that because nothng is acctually entered...
  14. D

    Conditional Formatting Dollar Amounts

    I have a column where dollar values can be entered. Could range from .01 to 3.00. I need to highlight anything that doesn't end in a 0 or a 5. I thought I could use a RIGHT formula, but it doesn't work as all the 0's are not included in this. Can anyone assist with the correct formula for...
  15. H

    Conditional Formatting Green & Red Cells

    Hi All, I look for older posts,but could not find the solution to my problem. I have a cell that needs to turn Green or Red based on a Target. The target is 65.7%. My cell that has conditional formatting, should be green because It hit the target of 65.7%, but it turns red. my conditional...
  16. C

    Conditional formatting for multiples of

    so we have a row like (row includes other higher values varying over hundreds of lines, but in essence these are what im after, its to do with overtime pay rates): <tbody> 1 1.5 1.2 1.8 2 2.4 2.5 </tbody> what i want to do is use conditional formatting to highlight as: colour 1 (x1.5) 1.5...
  17. D

    Conditonal Format Tab Color Depending On Contents of a Column

    Hoping someone can help me out here. I have a workbook with multiple worksheets and would like the worksheet TAB COLOR to be conditionally formatted due to the contents of the cells in a particular column. (The particular column may be different depending on the worksheet). For example: Sheet...
  18. S

    Conditional Formatting with Conditions

    I'd like to do a three color conditional format on one column IF another column has a certain value in that row. For example, if the country is USA and the sales conversion target is 20%, I want to have a rule that makes a three-color spectrum based on the actual conversion rate compared to...
  19. E

    Conditional formatting

    I have a scoring matrix for a number of services. Each service has its own RAG status. Example below. <tbody> Minutes <30 30-59 60-89 90-119 120-149 150-179 1 2 3 4 5 6 Serv1 3 3 6 9 12 15 18 Serv2 3 3 6 9 12 15 18 Serv3 2 2 4 6 8 10 12 Serv4 1 1 2 3 4 5 6 </tbody> I...
  20. zakasnak

    conditional formatting questions

    I have a spreadsheet (duh!) that uses dates for nominations of natgas. On Monday, I nom for Wednesday (highlighted), on Tuesday, I nom for Thursday (highlighted), etc. The problem comes when today's date is a Thursday, I want the conditional formatting to highlight Saturday, Sunday, AND Monday...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top