formatcondition

I have applied formatting conditions to a range of cells on the spreadsheet as shown in the image. I have VBA code which evaluates format conditions and outputs based on them. The problem is that when the conditions are applied in this way the VBA code pulls the formatting based on the first...

I have a worksheet with multiple conditional formatting conditions set up on it. These are typically set on whole column ranges e.g. $A:$A or $A:$Z etc. There is a table on the sheet and a macro I use to enable users to insert 1 or more rows in the table in a controlled fashion (using the...

I have this two functions in a module: And when I try to trace it, the execution is missed in the line: It doesn't matter if I put the line or not. But when I see the condicional format of any cell of the range the condition is correct but the format is not set. I really don't know what's...

Hi all, Frustrated with the ridiculous XL2007 propagation of conditional formats when users are copying & pasting cells, I thought I'd construct a CF auditing routing which would identify any CFs in a given range which apply to only one cell (it was a reasonable starting point given their...