conditional format macro

I have some code below which inserts rows into a table. However the table has codnitional formatting in there and when I add the rows it loses the conditional format, is there some code I can add to the below that adds the conditional formatting to the rows that have just been inserted, or if it...

Hi there, ive tried everyhting on this and cant get it to work!! I have a table where in Column A i have the months January, February etc. and data all along to AJ I want the entire row highlighted or bordered in some way if that row = todays month. I've tried a couple of VBA codes and...

Hello, I am a newbie to doing anything beyond the basics in Excel so you might have to very specific in explanations. unfortunately I do not know VB (some Javascript & bash) and afraid what I am looking for will require it. Thanks Environment: Excel 2013 Current Workbook layout: <tbody> A B...

May I know if it is possible to add this by range? For example, for range($E$5:$E$66), I want each of them to compare with the cell value on the next column (say $E$5 to $F$5....$E$66 to $F$66). I realized I couldn't just do it, so I recorded a Macro and would like to just use a short key on...

Hi all, I currently have a large data range which I will simplify as A1:F6 as shown below. In the G column I have a list of cell addresses calculated from numerous previous formulas referring to specific cells in the aforementioned data range within the same row. I am looking for a way to use...

Hi, I want to use conditional formatting on some cells using the following formula: =ROUND(SUMIF($D$4:$D$85,"New Profit",E$4:E$85),0)<>ROUND(SUMIF($D$4:$D$85,"Profit",E$4:E$85),0) When I record the macro, I don't see anything in the Sub.. Has anyone any idea if this can be done? Thanks, Eoin

Hi All, I've looked everywhere but cant seem to find code to conditional format an Incon set. All I need is code for a conditional format on a selected range. I want to use the (xl3Symbols2) with an input of 1 for Tick, 0 for Cross, and the ! for anything else. Can someone point me in the...

Here is what I need. I have a column that has percentages, say Column A. This column already has conditional formatting to change the cell color based on a specific, CAPS letter from another column using this formula: =NOT(ISERR(FIND("A",X4:X235))) What I now need is another conditional...