And, J$2 locks in row 2, for horizontal dragging purposes. Just an fyi - $J2 is a reference that locks the column. maybe because it is automatically flowing down the formula and so it interpreting it as "left not equal to right" in the left column and "right not equal to left" in the right column, so if you don't transpose in the right column you actually get what would be =G2H2. The other for Column G, which had the formula =G2J2. One for Column J, which had formula =J2G2. As usual you can use A1 or Row/Column notation (Working with Cell Notation). The conditional format can be applied to a single cell or a range of cells. So I tried this, and the way I made it work was with two CF rules. The conditionalformat() worksheet method is used to apply formatting based on user defined criteria to an XlsxWriter file. aren't $J2 and $G2 absolute references? I think you want =J1G2, no? Otherwise everything gets formatted based only on the comparison of the first two cells. I'm not sure about your specific issue, but playing around with this, I could not accomplish your goal with a single rule.įirst, I think your formula might be wrong. ![]() ![]() You didn't post the rule set so hard to see what you are doing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |