condition formatting

I have two worksheets, sheet1 is a table to list tasks with the unit number named "task" and sheet2 is a table to list the task handling progress named "progress" . and i need to color the task row in sheet1 in red if the same task is mentioned in sheet2 and date is mentioned as done in sheet2...

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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