conditional formating

Hi We are a charity running emergency shelter hostels. We have an issue I am trying to solve where a cell in sheet2 will carry a value which exists in a list in sheet1. I would like to colour this cell in sheet2 based on a value in sheet1. So if a cell on sheet 2 has the word Apple Street...

Hello, I'm very new to Excel (2010). I'm trying to figure out how to manage an inventory by keeping track of when an item is used, expired, or damaged and autopopulate that data on a second worksheet. For example: Column A is an order code ("offsuppencils") Column B is the item description...

Hi, I am creating and custom purchases statement that i want to record all my purchases. each row is an item purchased. however i have items purchased in USD,EUR and GBP. In one column i have this information (USD,EUR or GBP). i want the next column with the amount to change to currency format...

Hello, I currently have a piece of VBA code that converts an excel selection into a HTML email. In the workbook there is a number of specific conditional formatting formulas that are being used. When I run the HTML email macro it populates the selection in outlook (.display) but the...

Hello Excel Gurus, I am performing interval analysis with conditional formatting that highlight cells in a row where either an interval was missed or a defect is evident in reporting. Interval misses are red and defects are yellow. I am using the following VBA below in conjunction with the...

Hello, I have a large range of cells that I want to apply Conditional Formatting to as follows: If not blank & value is not between L6 and M6, then fill red. I would like to do this using a single format, perhaps using a custom formula? I will be putting it in VBA, but with a working...

Hi Guys, I'm new to VBA, so this problem might be not be really difficult, yet I cannot seem to find solution... I'll just list what I need to do: 1. Conditional formatting needs to be applied to columns P and Q =$Q1>$P1=> both cells turn red; =AND($Q1=0,$P1>0) => both cells turn...

I need some help please with conditional formatting of some cells. I have a chart with the days of the week across the top, dates just below and then a shift pattern below that. What I currently have is two conditional comments that work, to display the column with an ‘S’ in it (ie. Weekends)...

Hi, I have a tab (let say Sheet1) where I have a list of customers and their health status. In another tab (Sheet 2), I want to change the background colour of my customer, depending on their health value. What I've done so far, is to get the health value from my Sheet 1 and display it in my...

Rules *Students marked absent under the "All day" column must show supporting period absences. Conversely, students with absences in all period columns (Per0, Per1, Per2, etc.) should have an "All day" absence recorded *Every "All day" absence must be verified *As long as a student has been...

I'm trying to change a cell, at the bottom of a column, to a different colour once all the cells above, in that column, have a date in. Ie once all the cells have dates against purchase orders, then the cell would turn green and say Completed. I know you can use conditional formatting for part...

Hello All, I searched and found nothing so wanted to see if this is possible. I have a form that we print out each day and sent to a different department so they can perform updates within the system. Well they are missing ALOT of the information we provide due to lack of focus and reviewing...

Hello Everyone, I have a report that has to be sent weekly, then 4 weekly reports convert into a monthly report and then 12 monthly reports convert into 1 yearly report. Now the problem is that I need to do conditional formatting on a single column based on the Text values that another column...

Hi, I have been building a database for my small business for the book keeping I am currently using: Windows 7 64bit Microsoft Excel 2010 Basically I have a price column and a Income/Expense column. I want the currency value in the price column to be red text if the word in the Income/Expense...

I've never tried a forum before. So thanks for your help. I'm stumped. The formula below selects a value from 2 tables. I've tried and just can't get the formula that will work for conditional formatting. I need the formula that goes in the conditional formatting box: "Format values where this...

Hello, I need to copy a set of conditions for highlighting cells across several columns whereby the cell values changes as well. See below an example: My conditions are: - If equal to max value highlight green - If equal to min value highlight red Now I need to copy across several columns...

I am looking to CF based on the values in two other cells. But first I need to find the number within one column to another than format base on the third I have figured out how to CF on column to another (=COUNTIF(C:C,RIGHT(A1,5))) which works but I need I to format based on the third cell I...

Hi All, My worksheet shows me the date I last held a meeting at a list of customers (column F shows the date). If any of the dates in the column are over 3 years old (from today) I would like the date to turn red. I have tried various options within conditional formatting but can't quite get...

I am attempting to conditionally format a cell in the G column to change to red fill if the date referenced in it is within 3 months from today but excel only allows you to do it up to this month. I was wonder if someone could help me either get that formula started or show me where to find the...

Hi all, I cant seem to get my formula grammar down.. I am trying to write a conditional formatting formula for a long list of data, which would look something like this: =IF C1 is the same value as C2, AND IF B1 is the same value as B2, THEN highlight Row 2 red And it would look...