condtional formatting

I need to a cell (D3) on work sheet "Year Summary" to be colored red only if any of the following cells (C3:P4) contain anything (letters or numbers) in Worksheet "Jan 1-3". I tried conditional formatting but pretty sure not using the right formula because its not working properly. Please...

Hi, I have a large sheet with a selection of cells with a validation list in each cell (Yes,No,Maybe). Depending on the cell value I have a conditional format set of Green, Yellow or Red. So far so good However, I have inserted a new column at the start of the sheet now where the cell value...

Hi All, Thanks for checking this post, and thank you even more if you can help! I've had a search and found nothing the same as what i need to know, apologies if this has already been asked. I'm seriously stuck and in need of help, I need to plot a heatmap of data based on geographical...

Hi I am trying to conditional format a cell but am struggling I have a summary sheet, which I would like to autopopulate based on data on other sheets in the workbook I would like Cells A15 and B15 on Sheet A to conditonal format to green, if the there is no data in column M on Sheet B. In...

Good day, I'm using Excel 2010 and creating what is essentially a study tool - a comparison between two lists (one that the user populates and the one beside it which has the answers). There are three columns in each list but there are merged cells that serve as headers for each sub-section. I...

Dear All, I have a data file in which i have two column, 1st is Expiry Date column in which past, present and future dates are mentioned and 2nd is Status column in which user will mention status either "OK" or "Pending". I need a formula / conditional formatting which will start highlight (...

Hello, New user, 1st post! I have a Excel 2010 spreadsheet that contains 3 columns of (£) values. I am wanting to highlight a cell if one of these values do not match the other 2 columns. e.g below I would need the middle column to be highlighted as it does not match the other 2 cells. <tbody>...

Hello everybody, So far I have a conditional statement that goes up a column "U" filled with values, and when the value differs from the previous cell (below it), the statement executes, putting the new value in the column "V" next to it. My code: Dim var As LongDim counter As Long...

Hi Everyone, I am trying to use condtional formatting to highlight a row in a table if the order number is NOT on another table, on a different sheet. Example: Order Number 1001 is in my table on Sheet4, Once the order has been filled is comes off my "Pending Orders" table on Sheet1, which is...

hi I have a table inserted into my spread sheet, I have various conditional formatting rules on it, which depending on whether there is a value (anything written) in a cell in a particular column will turn the whole row a particular colour.. e.g if there is a date in cell A3, then the...

Hi, I have what seems to be a very complex ask however I will go ahead with what I would like to do. Each week I would like to import the Sat and Sunday games from English Prmier league from the internet. This data will be refreshed each week. I would then like to apply 4 points if the score...

Hi All, Firstly, I apologise if this query has already been raised. I did look to see if there was a problem similar to the one I'm experiencing, but I wasn't able to find one. Ok, here goes. I am trying to highlight cell relating to quantity of available stock. The cells contents have...

Hi! I have a seemingly easy question, but I just can't figure it out. I know that I can conditionally format a cell if the date in the cell is expired '=A5 < TODAY ( )<TODAY(). do I expired...how is A5-Z5, say let?s row, the in cell ANY if A1 format to want and A1, Cell Number Customer a...

Is there anyway I can print the conitional format rules. i would like to show my boss what I have done to create the color changes.

Simply put, I need to create conditional formatting so that after one year the color of cell changes - based on the date in another cell. The reference date is in cell E4. Cell E2 = Today Cell E4 = 8/26/09 This is what I have currently - it should change color on 8/26/10. It doesn't...