applied

Hi all and thanks in advance for your excellent help :) I've applied conditional formatting to an area of my spreadsheet so that when all cells containing N/A are coloured green. However, when I applied this rule not all the cells in my selection that contained N/A were coloured green. All...

Hello all, I'm looking to create a formula that will decrease a percentage applied each year by a 2.5%. For example, to start or year 0, 50% is applied. In Year 1 this is reduced 2.5% to 47.5%, in year 2 there is a further reduction of 2.5% to 45%. This continues until the percentage applied...

good day all, i need some macro to show me the reverse of current applied filter. For example i have a table and one column in table shows Dep A, Dep B, Dep C, Dep D etc. i apply filter on this column for Dep A and Dep C..... So Dep B and Dec D will be hidden. From here, i need a macro which...

Hello All, I am new to the world of using VBA and I am looking to get some help in writing a code that follows a set of conditions and applied it to a data base. I would really appreciate it if someone could assist me learning how to write the task rather than a straight up answer example...

Hi There, Any help with the following query would be greatly appreciated. I have an excel sheet titled "Main List" which contains a list of company names in column D. I’m looking for a macro (to be applied to a button) which creates a sheet and titles it according to the company name selected...

Can anyone show me how to apply the following conditional formatting using VBA? The above is the formula I have currently applied. The format will be that the text in that range will be coloured red and bold, but I only need this to be applied on every row between 7 and 451 where the cell in...

I have a pivot table pulling the count of attendees for various events. Of those, another column pulls a count of those who have applied. I need to insert a calculated field to find the percentage of those that applied based off of the total who attended the event. Should be simple to do, but...

Good day all, i have a question. I use excel filters all day long. I usually apply it to huge data tables on many columns simultaneously. It would help if i have a method or Macro which will remove all active filters except from the columns of active cell. Let me explain !!! Say i have...

Hello everyone, I am trying to write a VBA code which will contain my SQL code, and that code is to be applied on a table in access, and export results in another table in access document... any ides/help/guidelines

In cell E2 I've inserted a checkbox. Then I applied a Format Control to it so that TRUE/FALSE will appear next to it in F2. Now I want to replicate that checkbox down the column with each checkbox displaying TRUE or FALSE to the right of it. I can replicate the checkboxes but checkmarking one...

Hi, I have applied conditional formatting in range of cells like C1:D100. These cells contains formula like if A1>0 then "Fine", otherwise "Error-check again". If any of the cell in that range contains "Error" word then fill that cell with red color as conditional formatting is applied on...

Hello, Please have a look into the below two table. . and assume that 1st one is posting data and 2nd one applied data. I have to verify whether all the posting data are applied or not. If we use Vlookup or Duplicate formula that $2000 will show as applied but i have applied two only. one of...

Hi all, I have a pivot table, in which I have applied a conditional format. But it doesn't work. This screenshot will help in explaining what my problem is. https://photos.app.goo.gl/KL9QYLs2wtURwTtW2 As you can see, I have applied a conditional format to a certain field in my pivot table...

Excel friends, I am using the code below to change some cells conditional formatting. Since VBA sets "cel.Address" as an absolute reference by default. How can "cel.Address" be modified to be applied as a Relative Reference? For Each cel In Rng.Cells With cel cel.Select...

If I have a table with amounts greater than 100, can there be red font applied in Power BI? Similiar to Conditional Formatting in Excel?

Hello everyone, I have quick question. If conditional formatting uses TRUE/FALSE logic (is applied only on TRUE values), and Excel takes 0 as FALSE and 1 as TRUE...what is explanation for =MOD(ROW(),3) where values are always 1,2,0...and in this case, CF will also be applied on 2... if we use...

Hi I went to format Cell-->custom. I see different formats like #,##0 what does that format mean? how you interpret that format? also how can I know what kind of formatting applied on a cell? Lets say a cell formatted as %, how can I know this cell formatted as %. Thank you