conditional fomating

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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