conditional formatting

I'm trying to use conditional formatting to compare a static value with a dynamic value that will be updated daily. Whenever I try to use the conditional formatting, it compares to the first cell chosen rather than the one it should compare to. The table will contain 50 items if not more...

Hi all, I currently have a very messy sheet that looks like this: Essentially, row 1 is the heading, row 2-3 is the results that I want to produce through a text to columns, and rows 24-45 are the data that I currently have. The issue is that my cells have become messed up, so for every...

Hi, I'm putting a spreadsheet together that will compare National results with local scores. I think Conditional Formatting is what I need for this, but I'm not sure exactly what formula to use. The attached image displays what I'm working with, and the colour scheme that I need to...

Hello! First off, I know my excel is in German, but I would prefer to ask in English, as it is easier for me. This is an Excel sheet that will be used for sending out reminders for unpaid bills. Here I can list what each column is for, although most of them should be quite irrelevant for the...

I am trying to change font style of 2 repeating words that occur throughout a workbook either in a text string or singularly. Changes: "Chapter" to bold and red "Section" to bold and blue Looking for a simple code - thanks

Okay, so whether this is done by VBA or the conditional formatting tool isn't important to me, either would be fine. But at the moment I'm adding each rule manually in the conditional formatting tool and I've got about 200 of these to do and I know an expert out there has an easy solution for...

Hi, I have a single column of cummulative stock market returns going up and down on a daily basis. I'd like to have an up arrow show in the cell in question if the previous value in the column was lower and vice versa. By cummulative stock returns, I mean if A1 shows the returns for January...

Hi! I'm trying to apply some conditional formatting to an Excel worksheet with a macro (using VBA). Below are the conditions and subsequent actions I'm looking to execute: First: hide all rows (in the entire active sheet) if the value of the cell in Column G ="BID", AND if the value of the...

Good day. I have this formula for conditional formatting: =AND(AN$6=1,$AN$8:$BV$374<>"",$AN$7:$BV$374<$BX7) It strikes through the text if the conditionals are met... but the scrolling of this sheet takes a nose dive the moment I use it. How can I correct this? Should it be done in VBA instead?

Hello, I have a situation where I am trying to list all conditional formatting rules that are in an entire workbook. In this forum I was able to find a thread that is over 3400 days old. Thread is titled "List all conditional formatting rules in a worksheet". In that thread, this is the VBA...

I have this formula for Conditional formatting =ROUND($D$3*$C7,)>D7 and what I want to do... If the formatting is applied to any cell in range D7:NE41, then I want to apply that same formatting to D45:NE79 - the issue is that if I add that second range to the "Applies to" section of the...

Hi All I really need your help. I have an inventory in and out log. It logs date an asset was issued and date it was returned. I have everything in a drop down menu and i need the following. these assets are loaned out on a daily basis and returned on a daily basis. (Or supposed to be) there...

My data has many number wherein some values are between 0 and -1. I labeled all of them with conditional formatting. However, it took quite a long time to replace all of them by 0. Is there any solution that help me to finish this more efficiently? Thank you very much.

Hey all, I asked a question similar to this the other day, but have changed my approach and wanted to get some input. Based on the date ranges in the table below, is it possible to use conditional formatting, or VBA, to color cells a solid color. Even better, if possible, can I use a gradient...

Hi, I'm looking to find a way to highlight rows within this range (not entire row), based on the following two conditions: If any date in column A is a weekend, then highlight that particular row and/or If any cell value in Column B at min. contains the word "TEST" (doesn't have to match...

I've had issues with conditional formatting extending beyond the range it's defined for (for example, conditional formatting is defined for A3:G3, yet it also formats cells outside this range like A4). It seems to get triggered by the existence of conditional formatting in adjacent cells (but...

Hey guys, ** Context ** I work in television advertising, where we have to make sure that none of our spots (ie. the times when our ads are showing) are playing on the same station (channel) within a 16 minute interval. Each week, we copy all of the spots (often tens of thousands) that we have...

Hi all, I currently have a list that looks like this (albeit much much much larger in reality): I would like to create a slicer for column D (Height (CM)). However, my table is not a pivot table. Does anybody know how to do this? I read online that I have to go into the design tab and do it...

I need to conditionally format a column based on the text in 2 other columns and am just wondering what the best way to reference the entire columns in my formula would be Here is the code as it stands =AND(A1="MARIA1",C1="PORTUGAL: Segunda Liga") So if I wanted it to apply to all of A and...

I'm looking for assistance in setting up a macro to do the following. 1. Add a blank row in between each set of value from Column G. Column G is named "Handler (Job)" and may have different values on different tabs. Let's say it comes looking like this - Bob Susie Susie Lauren Bob Lauren...