Hi I am creating a conditional formatting script for my work sheet and I have it working but I need to set the formula in the script to a relative reference so it can be used in other places in the spreadsheet. When the script reaches the point where the line below is executed I have a region selected and I want to have the cell that the conditional formatting depends on to be three row down and 16 columns to the right. What I have below is giving me a type mismatch error. Novice here so please give me details The cell where the formula should be is $Q$110<0 THANKS!
Please Login or Register to view this content.
Bookmarks