conditional formatting

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

Hi. I have a simple sheet that shows the individual duration, in minutes, of a series of activities in column H, and their combined total duration, in hours and minutes, in column I. The heading of column I also displays the "target" duration. In this example, the target is 5:00 hours. Is it...

I have two values (potentially more later) that are amounts spent by different parties that I want to balance. I want to use a 3-Color scale, where a party that has contributed more will be more blue, and less will be more yellow. The closer to being balanced would gradient to the cells being...

Hi all, Would like to get your support to solve below issue. Thank you in advance :) Condition As long as the date in row 1 less than today => fill in grey If the date in row 1 = today => fill in blue If the date in row 1 > today & data is not blank => fill in Green Result by myself I've...

Any help would be amazing - I've built an order form in excel and using conditional formatting I want to have the size value columns that are in the 'size scale' entered not have any color format (as all size values cells start with being formatted with Grey). Basically just want to show people...

Is there a way through conditional formatting to highlight a column value if they have multiple values in one of the other columns (ex. STATUS - they could have both an Active and Inactive status. ID ID_RCD STATUS 123456 1 A some data 123456 2 I some data 123456 3 A some data 456789 1...

Hello, I am attempting to create a pivot table that would have Conditional formatting. I can add conditional formatting to the table as a whole, but I need separate rules for each column and excel just isn't doing it. I have done all the research I could think of to figure this out on my own...

Hi all, I've a table range from A1 to C5 and now if Cell A1 to A5 has a specific text "On Line" then i want to highlight that row only. i.e. if cell A1 has value "On Line" than i want to highlight row A1 to C1 only. Also note that cell A1 to A5 will get its value by VLOOKUP (not by manual...

I am trying to remove the standard Conditional Formatting I initially added from a sheet as I found that over time, there ended up being so many rules listed and the sheet became seriously slow. After deleting all the CF, it is now behaving as it should, but I still need to colour those columns...