conditional fomatting

Hi, I am a little foxed. I have a cell entry 08/10 Two numbers separated by a forward slash as text. The idea is that is a number is less than 10 its filled red if not green if there is an entry I was hoping that the following screen shot would do the trick, but alas somethings not quite...

Hello. Does anyone have a formula for conditional formatting to change the color of cells if the date in the cell falls within the past year. for example: I would want 11/16/16 to be a color, and 11/16/15 to not have a fill color. Thank you in advance.

I am trying to conditional format a cell so that if another cells value is 1, it will fill green. I have tried numerous different way but I can't seem to do this with a number, only text. Please help

If in cell c17 I type or paste the word "critical". It highlights that cell red. It also highlights d17:u17 red as well using (Use a formula to determine which cells to format). The formula is =c17="critical". This works fine unless I type in "This is critical" in cell c17. All the other cells...

Hello everyone, I'm a new comer, very nice to be here. :) I'm totally new to VBA codes and macros (just watched some videos tutorials and online discussions today), and couldn't think of any solutions for what I want to do, so hope some of you could help. I'm using MS Office Excel 2013, and...

Hi All, Problem/Headache: I am trying to apply some sort of conditional formatting based on a cell value however, I only want the formatting to affect the corresponding cell to left or right not the whole column. Not sure if that even made sense, sorry if it didn't. . Example: In B1 I have a...

Good Morning All, I have read several threads on how to do mass conditional formatting but still no luck. I have tried using formulas and everything else that I know of. I am hoping that someone here might be able to help me before I break down and do each one by hand. I have several cells...

Hi Newbie here I have a range name which I would like to format using conditional formatting. When I change the cells that the range name refers to I want the it to format the new range. This might not be the easiest way to do it so I'm open to alternative suggestions. Essentially what I...

<tbody> A B C D E F 1 Home Team Home Goals - Away Goals Away Team W-D-L<strike></strike> 2 NMFC 2 - 1 Chelsea 3 NMFC 3 - 1 Norwich 4 Liverpool 3 - 2 NMFC 5 NMFC 1 - 0 Arsenal 6 Manchester United 2 - 1 NMFC </tbody> Hello, My table...

Ok so I am sure this simple, but it have me foxed. I have a pivot table, which looks like below: <tbody> Hub Role B/F/A Sum of 23-2015 Sum of 24-2015 Sum of 25-2015 Longbridge Civils Site Supr Budget 0.20 0.25 0.30 Forecast 0.20 0.25 0.30 Actuals 0.10 0.25 0.35 </tbody> This is...

I'm trying to create a formula in Excel 2010 that changes the color of certain text within a cell--not the entire cell itself. Is this possible? For example, one cell says: "Nationals vs Orioles @ Camden Yards. JS, KC." Every time I type the initials "JS" or "KC" on my spreadsheet, I want "JS"...

Hi All I am really new to VBA and would like a little help with a challenge that I am facing. I would like to apply a conditional format to a number of cells based on Sheet 2 based on the cells values on sheet 1. For example if Sheet 1 cell B2= "1" then I would like to colour the interior of...

Hello! I am trying to highlight the row in green that if column e is greater than 500 and column f is greater than 5. also highlight in yellow if column e is less than -500 and column f is less than -5. Also if there is a zero in both of the cells I do not want it to highlight at all. (C)...

I am wondering how I could use the IF formula to create a conditional formatting rule that would highlight rows that are "unresolved" (an empty cell in the row). Basically, I have a spreadsheet that is documenting cases of unresolved credit cards being sent back to their respective departments...

example, I would like to find and highlight all instances of the words in column A throughout column B and C. Please help. Thank you. Happy The bike was black and green what are you happy about Dog Happy birthday to me did your cat and dog ride your bike her Cat The guy road...

example, I would like to find all instances of the words in column A throughout column B and C. Please help. Thank you. Happy The bike was black and green what are you happy about Dog Happy birthday to me did your cat and dog ride your bike her Cat The guy road his bike with his cat...

Hello everyone, I need to compare a list of 300 emails, which is one file, to another list of 4k emails in another file. I would like the emails that are found on the 4k list to be automatically highlighted. I have tried VLOOUP with a series of different settings and I have tried Conditional...

Hi I am an analyst/accountant for a UK retailer. What I have is a set of variances to forecast which I have developed into a variance "wall". Each brick in the wall has the title of the area it represents as well as: Actuals Budget Variance I like to use the conditional formatting graded...

Priority in CF Rules Manager's "Stop If True" GETS CHANGED while copying down! What to do?

I am creating a spreadsheet for my job and it would be really helpful if somebody knew a code or any way to implement this into my spreadsheet. Thank you, Chris