conditional fomatting

hello! i have a column of dates the employees were hired. i want to format these when they reach 10 years as of today and every 5 years thereafter. what formula should i use in conditional formatting?

Is there a way to have a sheet have the alternating rows but have a formula within it so I don't have to do double the work? I want to color every other row but one of the formatting options I do is a fade from my XLOOKUP or dropdown menu in the overall status and I want the white rows to have...

I need a vba script that will highlight the cells in column B that do not equal the value in the same row in column A as illustrated below Made several attempts, can't get it to work

So I have a list of numbers in sheet_A associated with a list of names, and then I apply the traffic light icon conditional formatting so that they have a relative conditional formatting in the list. Now can I somehow show a value from sheet_A in sheet_B which maintains and shows the icon...

We are using Ethernet cabling for a non-Ethernet application, and crimping the wires into a giant 96-pin connector. The internal wires in a standard Ethernet cable are colored Orange/White, Orange, Green/White, etc., where each Color and Color/White pair carries a differential signal, so each...

Hello, I hope you are having a good day. I'm trying to apply a simple conditional formatting using a formula condition: AH8<>H8 (if does not equal) fill with yellow background for AH8 if this is the case and AH8 has a formula in it =H8. So basically if value is different in AH8 than what...

Is there a conditional formatting that would reflect to (cell) based on (value chosen from drop-down list in different cell)? Condition : All cells containing the value of (Yes) the next cell will be highlighted in gray and not allow anything to be typed; if (no) the next cell will be...

I am trying to add conditional highligting for only 2 cells where the range has the same data. IE: A1:E1 with the exact same value of 6,0; 6,0; 6,0; 6,0; 6,0 The current formula I am using to highlight the 1st instance is: =AND(A1=MAX($A1:$E1),COUNTIFS($A1:A1,A1)=1) I NOW need to have 2 of...

HELLO, everyone. Im trying to figure out how to this conditional formatting. In the photo below shows the week schedule, where the desired input is the text "A". While the numbers below is the count for this "A". So my issue is to create a conditional formatting that anticipatedly highlights...

Hello, I am trying to make a table to input a set of daily data, so I have my dates (using a formula) as the top row, and have applied conditional formatting so that the WEEKEND dates are in blue and have strikethrough text. I would like to carry that formatting down to all the rows beneath each...

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

I have a table with a "DATE" column that I generally update daily with the current date, so my current conditional formatting for that column is - Cell Value < TODAY() - (with a green colour), so if the date is from yesterday or beyond then it will highlight green until I change it. But I have 2...

Hi All, I feel my question is rather easy but I'm making a total mess of it so far. Basically, I want to check the value of Column I, and depending on the text inside the cell, change it's colour (either red, orange or green). The column will contain either C1, C2, C3, ---- C74. And for...

I am trying to apply data bar individually for every Field in PivotTable Like this : I was trying to create a code to start new datarange for every active field, but got stuck with this. Dim pt As PivotTable Dim pf As PivotField Dim pi As PivotItem Dim pfs As PivotFields Set pfs =...

Hi, I have a workbook with 2 sheets, Old and New. Every so often I want to compare sets of data based on values in 2 columns, and if they match, highlight the entire row. The tables are laid out the same; Column A (Client) - Column B - Column C - Column D (Preparer) - Column E - Column F -...

Hi I am tying to continue a CD from top row of a table to the next 100 rows. I have tried the format painter but this holds onto the first row as its limiting factor, and i have tried removing all $ signs but is still not working A1 = 10 B1 = 12 - i want B1 to be red A2 = 15 B2 = 8 - i want B2...

Hi all, Wondering if this is even possible... Is it possible to set up a slicer so if when items is selected, the colour be synchronizes to the PivotCharts 'line' the Slicer is linked to? Furthermore, can this be applied to when multiple selections are made? E.g. Three people, Three names...

Hi I have a set of dates in A1, which are planned dates to complete works. I would like the cells in column B to highlight according to a RAG status. If the Dates in Column A1 is within 7days of Today(), the cell highlights red. If the Dates in Column A1 is within 7-21days of Today(), the...

I have a table of data. For ease, say there are four columns, titled division (e.g. Africa, Europe), country, region (north/south), and city. The data is all sorted from column to column. I would like, in each column, to have any of the same batch of data one colour and the next batch a...

I have a lot of different sections that need to be conditionally formatted for instance I have a lot of different rows that need to be formatted depending on what is in row 2 However, when you go to edit in the box it looks like this...