conditional fomating

  1. C

    Conditional Formatting based on Checkbox

    Hello all. I have Sheet1 where I want to put data on cells B2:E20. I want to place a Conditional Formatting on these cells. Basically, I want to fill the cell if a data is entered - doesnt matter what data, I will put something in that cell. However, the fill color on the cell will be dependent...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top