conditional formatting

I have a code that organizes raw data into multiple sheets, without getting into too much detail, it lists the task from the raw data with short descriptions, and completed date as well as scheduled date for each of the tasks, if the task was completed late (after the schedule date) I want it to...

Hello, I have a spreadsheet on Sharepoint that I'm trying to make work. The purposes: To allow people from our building can add their name and birthdays. To have conditional formatting that automatically highlights all rows containing dates from the current month. To automatically populate...

I was trying to provide conditional formatting in my Gantt Chart. However, I have difficulty developing a formula that will trigger to highlight the cell or range, as the date is not a usual one. I'm hoping that someone from this group can help me solve the issue. I manually provided the colors...

Hi, we have the following sheet where we want to use multiple conditional formatting Sheet is ABCDEFGHIJ1DateOrderDateP NameTGQtyRecd. DateRecd. Qty24/27/1087634/27/1050027/04/2010TEST 129/4/20105504/27/201050045/9/1020009/05/2010TEST 216/5/20102005/20/201015055/9/1015009/05/2010TEST...

Hi all, I want to highlight cells when the row has 5 consecutive (or more) "Need attention". I only want to highlight cells with a word of "Need attention", and only if there are at least 5 consecutive word of "Need attention". The cell values are from a formula. Thank you in advance.

I am trying to use conditional formatting for multiple cells. For every Friday, I would like to highlight red the ones that is our off Friday. I use a table of dates that I want to match against to highlight the red ones. Only one day gets highlighted. I thought I read that I can use the one...

Hello Excel Masters I have applied (3) conditional formatting rules to a range of cells (G3:HP204) If the cell value = 0 the cell background = no fill and the font color is white If the cell value is < another cell the cell background is red If the cell value is > another cell the cell...

Hi! I have question regarding the conditional formatting. How to show signal using conditional formatting icon set? I'm planning to make a signal when the 3 or 5 value is showing nearest value among them (example in the picture), then the signal will show red flag in C11. The thing is the...

Hi everyone, I am currently conducting some revenue variance analysis and I'm having a nightmare coming up with a conditional formatting formula that works for each of the 9 lines. Please see image attached. Column K, is how I'd ideally like the % revenue variance conditionally formatted...

Hi How I can do this ? For example, if I click / choose a date 11/04 in a range D2:J7, it should colorize the same date (and descriptions in 2 near cells) and same color in a range L2:N15 if the same date exist in column L. Is it possible by VBA or Conditional formatting? Thanks

I have searched this for quite a bit of time but couldn't find the answer. I have over hundreds of data, in columns and I want to create 3 color scale based on values in each columns individually (not across all the columns if I just highlight and create 3 color scale in one go). The only method...

Hi, I have a dataset where "Column B" contains dates that are repeating, missing, or random. I want to highlight the weekends for these dates. I have used formulas such as "=OR(WEEKDAY(C5)=7,WEEKDAY(C5)=1)" and "=WEEKDAY(B2,2)>5" but was not able to get the desired results. Need help in finding...

Hello and help! I am trying to set up a conditional formatting formula that highlights similar values in the same column (Column U) listed more than 2 times. The issue is that I need the formula to only match the text before the "/" character, since the number will always be unique. Example...

I'm running into errors with my conditional formatting. It's highlighting as a duplicate when it's actually not, but it's doing it inconsistently. I'm looking to highlight the cells in column C and D when there is a duplicate across both columns. Here's what I have as my conditional formatting...

This might be very trivial but I can't for the life of me work it out. 8-12 cells affected, using default conditional formatting rules 'Format all cells based on their values' - Format style '3-Color Scale' and midpoint Percentile '50'. Maximum and minimum are left as 'Highest value' and...

Hello The two images are examples of what I am working with. Briefly D4 = B4-C4 ..................... The same goes for I4 = G4-H4 The result in d4 shows that if I decided to pay this bill on January 31, 2023 it is too early there for it will stripe out yellow and red. < this is a visual...

Hi, I am currently trying to make a rule that will alert people that an incorrect value has been entered in table use to track metrics. The value entered in column D should equal the sum of values entered in columns G, H, I and J. I can make the rule apply to a single row in the table, but I...

Help! I really hope you can respond to this and help me! I need a formula(s) to apply conditional formatting based on various dates in a column both on the same tab and from a previous tab in the same workbook. Column A is "Date Received" (where the date will vary by when something was...

Hi all, I am trying to build a calendar so I can change the year and get a new year. I have got the days of the month to work but I want to conditionally format the weekend days. I work where there are 2 weekends. Some operated Fri/Sat and the others Sat/Sun. so I need it to be dynamic. The...

Hello, I'm having some issues with Conditional Formatting a column in one sheet based on a column in another sheet. The Conditional Formatting only works if both Sheets have all of the same lookup values. If the value doesn't exist in Sheet 2 for example, the value in Sheet 1 will return TRUE...