conditional formatting

  1. R

    Conditional formatting - cell equals another cell, formats range of cells - quick apply to multiple ranges needed

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

    Icon sets (up/down arrow) as values rise or fall

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

    VBA to hide rows and apply cell colors based on multiple columns' values

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

    Conditional Formatting causing scrolling lag

    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?
  5. R

    List all conditional formatting rules in a workbook

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

    Apply the same conditional formatting to another cell when it's applied to others

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

    Need help with formatting a cell which uses a drop down to display status when the date is older than today

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

    How to replace the values within the conditional formatting range?

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

    Coloring cells based on a date range

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

    VBA: Highlight row within range if a date is a weekend or based on cell value

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

    Conditional formatting spills into adjacent cells

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

    Conditional Formatting, Dates and Times

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

    Create slicer for a list without pivot table?

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

    Conditionally format column based on 2 other columns

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

    Macro Creation - Sort Rows, Add blank row, conditional format text

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

    VBA Conditional Formatting

    First of all I would share my data but it contains personal information about patients so I will abstain. I will preface through: in my role I receive many reports containing patient data and there is a lot of manual leg work to go and tell where the fallouts are. In this specific spreadsheet we...
  17. B

    Highlight duplicates cells, but ignore cells with a ?

    I've basically got a column of names. I want to highlight duplicates. Conditional formatting works well, but but many cells in the column = "?" as a place holder. Obviously this will get flagged as a duplicate as well, but I want to take any cells that = "?" out of the running. So, basically...
  18. J

    conditional formatting icon, use in if statement

    Hello! I have a a big dataset where I've used the conditional formating to color values that are grouped as: The values are in percentage of the total in that specific dataset, so all values are somewhere between 0 and 1. Above 20% : green traffic light 19,9% to 5% : yellow traffic light and...
  19. A

    Conditional Formatting If Other Column Contains Specific Text

    Hi all, My column C contains "Graduation Dates" and D contains Call Status (whether I have called). I want my conditional formatting to highlight my column C cells based on the following ideas: No formatting if date is far out Yellow for date is next week so I know I'll need to call soon Red...
  20. M

    Conditional format not working when pasting values

    I have a sheet with various conditional formats, I have noticed sometimes when copying value only into the work sheet that sometimes the conditional formats work instantly and some times i have to click into the cell and click back out to get it to pop. is there something I can do to get them...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back