conditioanl formatting

I appreciate any help with the issue am having. here is the what I am trying to do: Column A 35155976 35156348 35156348 35160550 35160550 35160550 35160550 35161189 35161189 35161201 35161201 I would like to highlight the rows (Entire row) for similar values in Column A. so since A2=A3 then i...

I hate to say that I cannot figure this out... but I cant.. I need a formula for: If the number in M4 is greater than the number in E4 then the number in M4 should turn red Thanks for looking

I currently am using this conditional formatting (applies to =$A$4:$A$20)(formula =AND(A4=J4,A4<>"") Example: In A4 I have B3335 and J4 I have B3335 so it turns A4 Orange The issue Im having is some times J4 may have for example B3335-100 so the formatting will not take place. I need it...

Hi - I'm a newbie here so apologies if my answer is to be found somwhere already. Excel 2010 conditional formatting - I want use conditional formatting using icon sets, however, I need to use my own graphics instead of the arrows, flags and other shapes available in the existing icon sets. Is...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

Hi, Please help in order to perform conditional formatting for entire row, if one condition satisfy for particular Cell then entire row should get highlighted. Thanks, Harish Kumar

Can anybody give me a reference with the different possible codes used in creating your own conditional formatting in a macro? I need to conditionally format cells, based on a different column of cells having a particular letter, to have a black up or down arrow. Thanks for any assistance!

Does anybody knows how to create a Line Chart with Conditional Formatting? I want to format the line as red if it is off the target and green if it is better than the target. Thanks!

I am having a lot of difficulty trying to make this spreadsheet run as smoothly as possible. I needed to add some columns to automate much of the repetitive data entry and this caused much of the conditional formatting to not work properly. I know the formulas should be an easy fix, but i can't...

hello all, I am using this code currently to hide a button as well as a few lines, but I am finding a new issue with it, and I could use some help. 1: Neither of my rows seems to be hiding 2: since cell M3 is filled in automatically, the button and rows I want to hide don't hide automatically...

Hello All, I am trying to enter a formula into conditional formatting that makes a certain cell range 'disappear.' Since I am pretty sure I can't hide individual cells, I am trying to turn all the text fill and borders white to become unnoticeable. My formula I am using is this: =IF+$M$3<5 I...

I am trying to do a conditional formatting of a column so when a positave number is put into the column cell the cell will turn GREEN, if a negitave number is entered it will turn RED Example cell B 2 = 6 > Cell turns green Cell B 3 = -5 > Cell turns red ect ect.... Thank you in advance for...

Hello all, Is it possible to add some conditional formatting to a group of cells to have a popup box appear with a message in it if a certain cell (on a different sheet) does not have any data entered into it? Additionally can I make a popup appear if the numerical value of a cell exceeds or...

Hi there, I have a relatively simple project (I have effectively been asked to turn an MS Excel spreadsheet into an MS Project one because...:confused:) sheet 1 named "Schedule" will have various bits of data in In sheet2 named "Graphical" I have the following B1:BMP1, Merged cells showing...

Hallo all... pls assist Have set up an roaming calander that is conditional formatted to colour the dates between the start and end date in "blue" from data sheet. If "jabb" appears in the next row i want the rule of the colum above "jabb row" to change to clear "no fill" as if a space was made...

Good afternoon everybody! I'm having a little conditional formatting issue that I can't seem to figure out. I have Inspection Date in Column M and Interval in Column N. I need to conditionally format column M to turn red when the Inspection Date <= Todays Date - 365*(1*Interval) Is there...

A friend of a friend created the below macro to highlight the first 13 characters in a cell in a different font color. Our system group policy disables macro's. I am able to run the two lines separately in VBA as a workaround. Is there a way to run both lines in VBA concurrently vice...

I am using a VLOOKUP function to get minimum and maximum values. With a conditional formating rule, I want to use the 3-color scale (Format all cells based on their values). In my minimun I choose type "Formula" for my minimum and Maximum. But went I insert my VLOOKUP formula, it does not...

<TABLE style="WIDTH: 317pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=423><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><COL style="WIDTH...

I have a multi-column 4 row table with zero or positive values. In each column I want to highlight the lowest non zero value if it is unique - not quite the same as the lowest unique value, which may not be the lowest value! So must be a Conditional Format formula I am relatively new to Excel...