conditional fomating

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. M

    highlight a cell if 2 conditions are met - looping grrr

    OK, I am irritated... I want a cell to highlight if two conditions are true. I keep getting a looping error. In cell A1 I want the following formula to work. =IF(AND(ISTEXT(A1),A28="Bath Day"),cellcolor=yellow,"") here is a copy of the area <table border="0" cellpadding="0" cellspacing="0"...
  9. andrewb90

    getting data from another cell only once

    I have two cells that give me a percentage. One is a cell that is the average add on sales percentage for the month and changes every day as new info is entered. On each day of the month I have one cell that reflects the current percentage calculated on another sheet and the other is the...
  10. G

    Conditional format base on varying data

    Good afternoon. I am creating a script that will upload a .csv file into Excel, name the uploaded data as a range, typically the month, this is then averaged with a high and low values assigned, typically +/_ 5 of the average respectivly. I will then apply a format blue for higher than average...
  11. T

    Returning a value with conditional formatting

    Good afternoon Is is possible to use conditional formatting to return a value? For example if column A has multiple values such as Dog, Cat and Bird and I wanted to set it up that anytime column A has value dog column B says Woof. If this is not possible or conditional formatting isn't the...
  12. U

    Simple Currency Conditional Formatting

    Hello, I currently have a purchase order database that lists all of the general PO information to keep a log as we assign numbers. I have one column for all of the amounts of the POs and I am hoping to add a few conditional formatting conditions to color the cell if it is in a different...
  13. J

    Return Closest Value

    I have a worksheet with data from A1 to F50, and there could be duplicate values, is there a formula that I can use in "Conditional Formatting" that would highlight the cells that are the closest to the value I enter into another cell without going over. Example if I enter 50 I would like to...
  14. T

    Conditional Formatting in Excel 2010

    I recently upgraded my Excel version from 2003 to 2010 and am having a problem with a simple conditional format that worked in the previous version and sort of works in the current version The worksheet does the following conditional format: -if the current cell matches any cell within a...
  15. J

    Conditional Formatting Question

    Hello; I work in a call center that handles several different clients. I am creating a report to allow the operations manager of one of these products to see how long an agent is out of schedule adherence. I am trying to get the report to not only show the time in Hours, Minutes and seconds...
  16. pedie

    Need help with Conditional formatting. Thanks for helping :)

    if in a cell any of the word or spelling in the word matches the word or spelling in A1 then i want the whole cell to be hilighted with RED... for instance; if i write a word in a1 as "Add" and in b13 i have a word Addidas I want the whole cell to be hilighted.... Thanks for helping...
  17. pedie

    Conditinal formating - help please.

    :confused:if range (R1:R29) is not blank then hilight red in coresponding range from M1:M29. thanks

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top