condiational formatting

🤓 Good day my fellow nerds, I need help so I came here to see what Master Nerd could be so kind to solve this issue I am having. What I am trying to do: Using Conditional Formatting, I would like the = function to pull text from one cell to another based on a Start Date. Example: Text in...

Hello, I am trying to create some rules where the cells will change colors based on two dates and a running total Month by Year. See Below Expiration Date Commencement Date Jan 2023 Feb 2023 March 2023 April 2023 01/31/2023 04/05/2023 Colored Cell - Expiration Date Colored Cell -...

I have a computer generated list of skills for 60 candidates. The goal is to build a table that tallys the skills across all candidates to determine which skills are most frequest there most important. However the list of skills I have for each candidate is messy. For example, Candidate A...

Hi to all, I'm trying without success to set a conditional formatting for the row when a change happens in column C adding blue background. Is possible without using a helper column. The input range is like this...

Hello I have spent my whole 2 full days trying to solve this one and i was no able therefore i am asking please for your help. I have a simple table that includes 3 Tactics : A, B and C. Each Tactic is defined by 2 numerical parameters (Parameter 1 and Parameter 2) which are set and fixed in...

Hi I need your help in calculating the total sums of all the cells with yellow color. As per the example mentioned below are two columns mainly Name(C) and sales for the month (D) Now as you can see there are certain cells in the Name column (C) like C4,C7,C13 and so on which turn yellow. I need...

Hi there, I work in a hospital. I'm creating a sheet to monitor the client's waiting time. I would like the color of the cell to turn green the moment the arrival time is inserted, to turn yellow after 15min of wait, to turn orange after 30mins and red after 1 hour. I'm struggling to write...

I have a big data excel file, there are many negative numbers. Now I want to highlight all the negative values and then multiply it with a specific number (for example 0.5). Could you kindly show me how to do it? Thank you.

Hello, I'm pretty new to using Excel to it's full potential. Now I'm trying to get some conditional formatting done. I want to use the data from Sheet 1 to colour some cells in Sheet 4. I want to use the date Sheet 1, B3:B33, to Sheet 4, C4:AG10. When there is a value (1,2,3) in Sheet 1, I...

Hi, I have a very large worksheet that has gotten too big and too slow so I am trying to get rid of formatting and volatile functions among other things where possible. I currently use the built-in conditional formatting to achieve the result mentioned below and would like to find a way to do...

Hello!! I would like my column of dates to have 3 colors. Let's say that the date expires after 12 months. Based on the current date 6/1/2022 (or current year) Ex. The date entered is 4/13/2022 (this would be green) Ex. The date entered is 6/15/2021 (this would become orange) Ex. The date...

Sorry if this is a dumb one. But let’s say I have a date in one cell past/future dates how do I format that to turn the row red after 4 years has passed from that date?

I need a conditional format- the one I know will not work :( Here is what I need: IF i8 says "beaumont" then I need the numbers in L8 to copy over into T8 another example If i11 contains "Ocala" I need the numbers that are put into L11 to copy over into T11 Tried this and it does not work...

Hi, I have a spreadsheet with columns G-J setup with conditional formatting based on dates. the cell will change to yellow if the expiration is 60 days out, and will turn red if the expiration date is 30 days or less. I would like to setup a vba code that will give me a pop-up message upon...

Hi all, I am trying to use conditional formatting / VBA / whatever it may be, to match the destination output formatting with the source formatting. My lists of data vary in length and formatting. When I input a value into X1 my lists of data appear but I want the formatting to move with the...

Hi there, I'm new to the forum. So please be gentle :) I'm trying to come up with a solution to have a column of numbers appear in a graded color sequence (similar to what the color scales in conditional formatting do), but have the high and low numbers used for the grading changed based on...

I am trying to use conditional formatting using a formula with a range. I am not getting the results that I want. Can you use a formula with a range for conditional formatting: The condition is numbers with the last two numbers after the decimal point that end in a odd number and any cell that...

Hello, I am trying to Highlight multiple cells based on a specific cell. If cell K32 = True, I want cells B2:G239 highlighted in one color and if K32 = False, then no change. I have tried the following with no luck: Thanks in advance for any assistance!

Hi there. I'm using Excel for Mac 16.53, with an Office 365 subscription. I'd like to create a macro for repeated use to apply borders to my spreadsheets whenever there's a change in value in column B. But I want to do this via Conditional Formatting, as the values in the spreadsheets can...

Hi guys! I have a column that I need to color with conditional formatting based on two different criteria. I am using the following formula in the conditional formatting pain and it does work: =AND(AC2="Yes", AK2=INDIRECT("Partners!B6")) The issue is I need the range of Partners!B6:B not just...