Attention - ExcelForum Rules have been updated as of August 2023. These rules apply to everyone for the benefit of all, please take a moment now to read them so you will have no issues in complying with them. Please read them here . New Notice for experts and gurus: Recently, it has...
always somewhere within the table). Every time I insert a row, a new conditional formatting rule, identical to the existing rule, is created to reference the new row. I end up with hundreds of conditional formatting rules, instead of the 3 original rules I created....
I don't call myself an "Excel Expert" by any means, but I like to struggle with things until I find some sort of simple solution. In my case, I have 3 x CF rules applied to 2 different columns in a table, as example: "=$Q$2:$Q$185"... ...
Calculate YTD, Previous YTD in the same query calculated field with decimal place Calculating 30,60,90 Days Totals in sql Calculating Average between two datetime columns Calculating the RATE as the similar financial function in Excel - SQL Server 2014-2016 Call a webservice from TSQL (Stored...
Having said that and after playing with it for several months I discovered all the quirks and rules to using it and got it working smoothly. The basic steps go like this: 1. Open a document and save it right away as a .doc file not a .docx file 2. Link a spreadsheet to the ...
Attention - ExcelForum Rules have been updated as of August 2023. These rules apply to everyone for the benefit of all, please take a moment now to read them so you will have no issues in complying with them. Please read them here . New Notice for experts and gurus: Recently, it has...
need help with case statements with overlapping rules Need help with running javascript in stored procedure within the html body Need help with trigger for looping through multiple values from inserted Need help! Issue getting TempDB files removed Need powershell script to run sql query import result...
The issue comes when a row is deleted. The CF range then changes from $E:$E to something like $E$1:$E$20,$E$21:$E$10k (10k=whatever the max row number is in Excel) and it becomes unwieldy to maintain. I will also find CF rules duplicated when I check the CF for ...
Kjell Rilbe I don't call myself an "Excel Expert" by any means, but I like to struggle with things until I find some sort of simple solution. In my case, I have 3 x CF rules applied to 2 different columns in a table, as example: "=$Q$2:$Q$185"... ...
Attention - ExcelForum Rules have been updated as of August 2023. These rules apply to everyone for the benefit of all, please take a moment now to read them so you will have no issues in complying with them. Please read them here . New Notice for experts and gurus: Recently...