conditional cell colour

Hi guys, I've been trying to work this out for over a month! I have a spreadsheet that includes due dates for certain stages of a complaint. Stage 1 must be actioned within 5 days of the due date, Stage 2 must be actioned within 10 days, Stage 3 is 30 days and Stage 4 is 56 days. The days...

Hi I'm looking for some help please. I have a power pivot table that has some data slices to create a sort of reporting dashboard. The data in the table therefore changes depending on the slice selected. In addition the source data is changed every week (manually) and the pivot is refreshed...

Good day everyone and professionals in the house Please I really need your help with this, I have been trying to count conditional formatted cells based on it's colors, but when I didn't find the appropriate code I had to start filling it up manually. So there are 3 major colors there Green...

Hi All, I hope you can help? I am quite desperate! I need to highlight only the 1st instance of MAX value in a row over 5 columns. IE: A1:E1 with the values being: 7; 7; 5; 6; 3. I want to highlight ONLY ONE/THE FIRST instance of the 7. What do I need to add to the formula (which...

Hi All I really need your help. I have an inventory in and out log. It logs date an asset was issued and date it was returned. I have everything in a drop down menu and i need the following. these assets are loaned out on a daily basis and returned on a daily basis. (Or supposed to be) there...

I've read similar formulas and threads, but I'm not skilled enough to apply it to my current situation. A sample of my data would look like the attached picture. Hopeful someone can lead me in the correct direction! Trying to use Conditional Formatting to highlight rows with duplicates in cell...

Hi after a formula for conditional formatting In column A I have dropdowns where I select an item. Col B.C,D are amounts Col E is a final amount I want it so in Col E the formula is if Col A sees a word then when Col E is greater than 80 it will be green. If that makes sense :)

'Good afternoon all, I'm looking to conditionally format the below pivot table based on 0s on consecutive dates for each person. One consecutive '0', I want highlighted in pink, if it is 2nd consecutive '0' highlighted in red, and 3rd consecutive '0' or more, highlighted in a darker red. Also...

Hi peers, I was wondering if there was an easy way to highlight differences between 2 pivot table columns? I have a pivot table with 325 columns and I need to highlight where the values in the cell changes between the 2 columns: Im looking for a quick way to quickly highlight changes C6 &...

Hi Everyone, First time poster here, and man do I need some help. I am working on re-creating an "Activity Workbook" for my team to use at work. The original Workbook was created some years ago by someone who no longer works for my company, and it is in desperate need of updating. No one on...

i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????

Hi, I am trying to conditional format a sum cell based on other cells colors. I have A1 which sums A2 to A5. A2 to A5 are conditional formatted as follow: if empty red, if any number turns white. A1 is also red and I need it to turn white only if ALL the cells below (A2 to A5) have turned...

Hey there everybody, I'm working on a sheet that checks if one's answers are correct, based on given answers column. I want that if a cell value equals to the cell next to it, the cell will turn green (or red if it's not) I managed to achieve that using conditional formatting, but the problem is...

Hello. new to here need some help with checkbox and conditional formatting, ill explain my problem. i have a column, eg A, which has dates in, so different dates in each cell in column A i have set some conditional formatting to change the colour of the cells in A depending on the proximity of...

Hi All, I am new to making macros with color conditions and I have been having trouble figuring out the logic to my code. I have a table with various rows of jobs with their start and end time on a given day and each of these jobs can pass through multiple machines which are also included in...

I have a spreadsheet which has due date in column AB, and a completed date in column AC. If today's date is = to AB and AC is blank, I'd like AC to turn orange. If today's date is +1 day greater than AB and AC is blank, I'd like AC to turn red. If a date is entered in AC which is either equal...

Good Day all I have been experiencing an issues with a very small spreadsheet, causing me a major headache. I have a set of key dates across columns M, N, O on row 4. M4= First Draft N4=Final O4= Mobilization/ Start Date First draft needs to be received 8 weeks prior to mobilization and final...

Hi, I'm currently working on a project where I have a number of statements which are rated between 1(Strongly Disagree) and 4 (Strongly Agree). For each organisation I am presenting their mean average on this statement against the combined mean average for all other organisations, and I would...

Hi all, I have a calendar in year view that has the dates coloured based off of the type of event it is e.g. meetings are orange, reports due are blue etc etc At the top, I have a legend/key, and what I want to achieve is that if the user clicks the Legen that is for meetings (orange) then all...

I have code that runs multiple query's from the same Excel table and after each query is ran it saves it as a PDF file. The code works great but on the larger query's it doesn't allow the conditional formatting to update before creating the PDF. I have tried may ways of getting it to update the...