conditional formating

3 years ago as beginner VBA programmer I developed an application for the Food Bank: a "hand-out-list" for food-packages based on client-data in our "dossier"-system. Data extracted with Power Query and "enriched" with a VBA-script to the resulting "hand-out-list". List size about 730 rows...

Hello, I'm wondering if you can change the colour of a cell based on the colour of another. The idea is to change the colour of one cell, then have several cells (which are seeds/children of the origional cell) to change to the same colour. See below/attatched for desired end-result. I wonder...

Hello, I have a sheet with a range of cells that have a variation of the following formula in them ( =IF(Research!V1="","",Research!V1 - of course, "V1"). Basically, the sheet is a "table of contents" of sorts, that aggregates data another sheet ("Research" sheet). (Please see the attached...

Hi, I'd appreciate any help with 3 conditional formatting issues I'm trying to work out please If the date in cell H has passed and there's a date (any date) in cell I then turn it green If the date in cell H has passed and the cell in column I is blank, change the blank cell red If the date...

Greetings, I have a spread sheet that I use as my log keeping Blood Sugar Readings. It uses Vlookup and it works. But now I'm allowed to take addtional 2 or 3 units of insulin, My Choice over what Vlookup returns. By the way, 2 is a light color, and 3 is a darker color. If VLOOKUP returns a...

I am working on a sheet where we are tracking a person by the number of issues during the year and the reason. I have included an example spreadsheet. Columns A-C will change depending on what is found during the review, but Column D has three options to choose from. Once a row has been updated...

I am working on a sheet where we are tracking a person by the number of issues during the year and the reason. I have included an example spreadsheet. Columns A-C will change depending on what is found during the review, but Column D has three options to choose from. Once a row has been updated...

i have MS 2019, Conditional formats in a works sheet. when a row is deleted the Conditional formatting brakes ie F1:F1000 is set but i delete F20. i now have CF as F1:F19,F21:F10000. the CF now skips F20. i have to reset every time. and with 10 CF it is a real problem. any solutions...

Could you help me to write the formula for this problem A B C D Buy 110 109 Sell Now Sell 109 110 Buy Now If A="Buy" & B>C then D="Sell Now" If A="Buy" & B<C then D="Buy Now" If A="Sell" & B<C then D="Buy Now" If A="Sell" & B>C then D="Sell Now" If know how to use this...

Hi, I need to apply shadow to alternating lines that are ordered by country. I've made a series of attempts with the mod function and counting but nothing produces the effects I want. Download example

Hello! I want to make a pivot table to control clients' payments. This pivot table has as source a table in another sheet, like this (I made a simpler table just to use as example): I want the pivot table to have these elements: Row1 - Client Row2 - Type of income Column - Month Values -...

Hello Everyone, I am trying to make a excell where I have different activities spread out on a time plan, The idea behind the excel is if you imput a date in activity A then that activity name will show in the left table which is spread out on calendar weeks, below each row i have set up an...

Hi Everyone, I pretested this on my sheet to show for true DC and false STORE but when I try to use it for conditional formatting it doesn't work. =IF(AND(C2<>3,B2>800),"DC", "STORE") I have it selected for the entire B:C columns. Just want it to highlight if anything in the C column and B...

I know I am overthinking this. It is not a difficult task. For the life of me, I cannot figure out a simply Conditional Formatting. I have 2 pieces of criteria: If the value in cell D23 is equal to or less than 0 then highlight D9. If the value in cell D23 is greater than 0 then highlight D24...

Hello, I've been trying to delete rows in my data set that contain the following keyword "lename" This is the following script I found and the following error Script : Sub Delete_All_Rows_IF_Cell_Contains_Certain_String_Text() Dim lRow As Long Dim iCntr As Long lRow = 150000...

Hello, I was wondering if I could tell excel to insert a value (1 or 2) along all of column B, based off the values that are in column A. For example If A = 1 or 3 or 5 or 6 or etc... Then values in column be should be 1. and If A = 2 or 4 or 7 etc... Then values in column B should be 2...

Hi. I have created a dailywise progress report of a project using conditional formatting. The project is of approx 6 months duration. The project being a lengthy one, it is not possible to print the whole progress in a single page. For that purpose, I have created a dynamic calendar showing 12...

I have a spreadsheet of 1400 students and I'm trying to find which ones are eligible for our program. I have adjusted gross income in one column and dependents in another column. I have a countifs that accurately tells me how how many are eligible. But I can't figure out how to highlight the...

I am sure there must be a simple way to do this but I cannot find the solution by searching the web. I am looking at patients with burns. Each row represents a unique patient. The diagnostic code for the size of burn occurs on one of four columns in the worksheet. I have used conditional...

Please can you help I am looking for an excel formula to highlight cell with Invoice number (Column B ) that are partial similar (eg 51070122 & 510701-22 ) and the supplier ID Colum A match if possible to bring the amount in column D <tbody> A B C <tbody> SuppID </tbody>...