conditional format

Hello everyone! I have a small piece of code that will be used to compare a column (D) with the values of columns A B and C. It will later compare the column E with B and C. One of the objectives is to compare each cell from D and E with the correspondent cells in A B and C. Example: If D1...

Hello! I'm trying to find a way to set a Conditional Format for Column A based on text or color of another cell range. More specifically, my target range is $A. If $B through $H is either grey (it would be grey based on other set Conditional Formats), or contains an "X", I want Column A to be...

Hi Folks, I haven't had a chance to use VBA in quite awhile and so I've fallen out of practice. I have a worksheet with 17,000 rows (growing by approx 1000 a month) and conditional formatting set to change the fill colour of some rows (entire table row) based on the values in column 12 and 13...

Hi! I have created a pivot table that shows customer in column A, then the sales and sales difference in percent in the following columns by month. So column B & C are grouped under January with actual sales and percent difference from previous month (since there is no previous month, it is...

I want to utilize conditional formatting and need assistance with a formula to use in it. I want it to turn the text in cell M16 bold, red, italic if any of column M equals less than its corresponding line in column F. I know how to write a formula for one cell but not for a whole column. For...

I am trying to set up a conditional formatting rule that will automatically SUM the value I input into the conditionally formatted cell with a number from an adjacent cell. For instance, if I apply this conditionally formatted rule to M1: =SUM(K1,M1) I would like whatever number I input into...

I am trying to find a formula that allows me to do the following in order: 1) If the group ID is the same AND (2) if the Part # is the same as the (3) Part # with the minimum group price, highlight this. For example below, I want to highlight part # MPN1 because it is has the same GroupID and...

Hi. I would like to have conditional formatting done on an Excel Table based on the MIN and MAX values of every row in the table. Cells of the MIN values are to be highligted in RED with WHITE font. Celss of the MAX values are to be highlighted in GREEN with WHITE font. I was able to find VBA...

Hello, I've created a weekly planner for revision, it has a start date, duration and % completed. The dates are in columns eg 29/03 am and 29/03 pm... It's all great when i enter the duration as 1 day and it highlights both AM and PM for that day. Can anyone tell me what is the conditional...

I have searched the web for a solution to my question with no luck. Here is my issue: I have cell A1 with a date (any date), I also have two named ranges. One named Holidays and the other one named Payroll. They are used to identify the company's holidays and the payroll dates. I need to...

Hello guys I wasn't expecting to post a question here, but here it is: related to another post here (https://www.mrexcel.com/forum/excel-questions/1090639-formatting-cell-value-based-another-cells-colour.html) I decided to make a small UDF to determine the color of a cell. At first it all went...

Hello I have an spreadsheet and in a certain row I want to add some of the numbers together, I only want to add together the numbers that are bellow 20 and are conditional formatted to turn green. Is there a formula for this? Thank you

GentlePeople, I have a Question about How to get my "month" selection to automatically increment +1 for each new month? I have a few different ways that I have thought it should work, but doesn't. <tbody> Circle the Month: 1 2 3 4 5 6 7 8 9 10 11 12 </tbody> This is the way the month...

Hi guys, if anyone can help me get the macro for this to work, it would be amazing! My VBA is lacking a little and am losing my head over this - any help would be greatly appreciated: 'if any cell value in range L3 to P73 is = 2 in the OLD v New Check Sheet 'then find corresponding cell in...

Hello Mr. Excel Members, I'm hoping someone can help me format numbers based on text. Scenario: Cell A1 contains 5 unique names in 'text'. (Price, ACV, Units, etc.) If A1 contains the word 'Price' I want the number in B1 to be formatted as currency ($00.00) If A1 contains the word 'Units' I...

Column K has values that may contain a "✓". When a ✓ is present, I would like the row that the ✓ is on to highlight between Column A and J. I'm not sure how to carry out the process all the way down the document, 2000 rows or so. Thanks for any help. K4=✓, So highlight A4:J4 K72=✓ A72:J72

So, in other words: I have cells that contain text strings. The text strings may or may not contain numbers. In the event that they DO contain numbers, I'd like to set up some way to automatically make JUST THE NUMBERS bold. \ Is this possible? Either via Conditional Formatting or VBA? Thanks!

I have searched for this. I have tried to retrofit other conditional formatting threads. I thought I was close but couldn't get it to function. I figure this is easy and I am just on brain melt. I am trying to make a dynamic shift calendar and when someone changes the operator who is on...

I have a ODBC query where I want to highlight certain rows when a cell contains the number 1. This last cell is outside of the ODBC query. So far I cannot get the whole row to highlight only one cell. Any help would be greatly appreciated. Thanks Jim S.

I am trying to format cells based on a calculated percentage. It's a very simple calculation, =K2/J2 which produces a % value. When I apply a conditional formula, of any kind, it only recognized the data as the most complete value in the condition, i.e., 100%. I've done some simple test...