conditional fomating

  1. D

    Conditional formatting transparent color

    Hi, Is there a way to use a transparent conditional formatting to put a "shade" over cells with true? The result i'm looking for is let's say a cell has already been manually highlighted with a specific color, if the conditional formatting is true, than a color with transparency will be shown...
  2. K

    Extracting Unique Items from a List w/conditional formatting?

    Greetings! The project: I have a large set of tables in one tab that is acting as a tracking system for team participation. When a member doesn't show up, I'd like to ask the captains to indicate the missing participant with either a color or italicizing/strikeout. I would like a list to...
  3. smide

    Conditional formatting - highlight text cells based on values other column

    Hello. In columns A, B and C (A2:C600) I have a lists of different towns (column A), customer names (column B) and buying price for each customer in column C. In columns D and E I'm receiving new list (towns and customers). I'm monitoring top 3 customers from each town (top 3 buying...
  4. H

    Conditional formatting by using formula

    Hello, I have few figures arranged in row. In columns 1 i have a figure for reference and I want to highlight figures from columns number 2 to 9 in such a way that summation of those highlighted figures from columns 2 to column under consideration shall be less than figure in column number 1...
  5. C

    conditional formatting for individual byte in data string?

    I tried to post this earlier but I think something went wrong. I have a question regarding a VBA possibility or capability. I have the following data layout Created by hand. Is it possible to create it through VBA? A B C...
  6. S

    Conditional / Drop Down List Multiple Filter

    Hi everyone, Background: <tbody> A B C D Policy Issue Service Benefits Application Service Request Analysis underwriting Policy Accounts Payout Payment Admin </tbody> <tbody> </tbody> The Blue text in Column A is level 1 data; the red text in B,C and D column is Level 2 data...
  7. K

    Need Two Formulas - Calculate Days Over Due and Turning Row Red

    <tbody> MDT Date Next MDT Was MDT Met? Days Over Due 03/31/17 06/30/17 N 02/28/17 05/10/17 Y </tbody> First formula or conditional formatting is to create a formula that will turn the entire row red if the following conditions exist: 1. Column C is a "N" 2. Column B is past today's...
  8. L

    Conditional formatting

    Hi all, I'm looking to create a formula for conditional formatting that works as thus; - If D4 to D401 contain the specific text "Bronze" then the row (A through to Z) it is in will be colour1 - If D4 to D401 contain the specific text "Silver" then the row (A through to Z) it is in will be...
  9. J

    Conditional Formatting That Indicates Multiple Conditions

    Hi Folks, We're using Excel 2016 on Win 10 pc's. We use conditional formatting to change the color of a cell (to pink) if the number in it is <= to 100. That is working just fine and tells us our inventory levels are too low and we must reorder now. What we'd like to do, however, is keep...
  10. W

    Conditional Formatting ?

    Hi there... I have a training matrix... I want the format to change when the original training date exceeds 3 years relative to todays date. Example: A2 = Johnny Smith B2 = 10/06/2012 C2 = 10/08/2015 (3yrs later + 2 days make me red!) Column B is the starting dates for specific training...
  11. H

    Conditional Formatting Issue

    Hi All, I am currently setting up a file for my new department I have just joined. They are looking to make their excel documents more automated to save time. One of my current tasks is to change cell colours depending on what is contained within the cell. I can easily conditionally format the...
  12. S

    Conditional format formula to look for duplicates in multiple columns

    I am using excel for making out a shift schedule for my company. How do I create a conditional format formula to look for duplicate initials in multiple columns and to repeat the assessment independently for many more rows? Additionally, the formula would only look at the first 2 characters in...
  13. H

    CF in a cell with 6 conditions

    I want to formulate 6 CFs in a cell B1 to generate either of the value 1,2,3,4,5,6. 6 CFs are to be formulated to generate either of: CF1=1: A1 is less than B1; B1 is less than C1 and A1 is less than C1 CF2=2: A1 is less than B1; B1 is greater than or equal to C1 and A1 is less than C1 CF3=3...
  14. T

    Conditional format not applied to whole range of cells

    Hello, I'm having issues with conditional formatting being applied across a contiguous range of cells. Set up: BA133 is a merged set of BA133, BB133, BC133 BD133 is a merged set of BD133, BE133, BF133 BG133 is a merged set of BG133, BH133, BI133 What I want to do...
  15. Q

    Change cell background color based on another cells background color

    Hi guys. Quick question, is there anyway to change a cell background color based on another cell background being a particular color? I have a row with conditioning format that changes the background color based on a specific text. I would like to add a cell at the end of each row that would...
  16. N

    Match one cell then compare another

    So I have a master asset list (sheet 2) asset number, location, type and I have a site visit list from a colleague (sheet 1) location, type, asset number i want to be able to look up the asset number from site list and find the asset in the master list then compare the locations and...
  17. P

    Conditional formatting a row based on change in data

    Hi trying to shade rows in groups based on when the data in column 1 changes. ex. col A B C 1john data data 2john data data 3jane data data 4 jim data data 5jim data data Shade 1 & 2 with john, the whole row no...
  18. X

    Using Conditional formatting with subtotals

    I am trying to work out a spreadsheet that I am using conditional formatting to highlight every two rows. I have 2 lines for each item and i need them to be grouped together. I can get the formula =mod(row(),4)<2 to do this, but then when i go to add the subtotals for each section it screws up...
  19. L

    Conditional Formatting Only Applying to One Column

    I have two similar worksheets that both have a large amounts of data. I conditionally formatted one to have every other row filled light blue, to make it a little easier on the eyes. On my first worksheet it worked great, but when I tried to do the same on the second worksheet, it only applied...
  20. C

    Conditionally format based nodata in 2cols but had text in another

    Hi, I'm trying to apply conditional format to any row that has textbin one column and no data in two others. ....................Col C.............Col J.........Col K Row 1...........Text a............1...............1 row 2............Text b.............................. Row...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top