Thanks to "Can Google Spreadsheets conditionally format based on a previous cells content?", I understand how to apply conditional formatting to a preceding cell, if I'm using a simple comparison, but what about something more complicated.
For example I have data in a column in the following format:
B4 | C4
--------------------------------------
123 / clientname1 | 143 / clientnamea
345 / clientname2 | 143 / clientnameb
With a one off formula, below, I can split and compare the two numbers:
=(TRIM(LEFT($C4,(SEARCH("/", $C4))-1)))-(TRIM(LEFT($B4,(SEARCH("/", $B4))-1))) > 0
However, how would I create a reusable rule that uses something along the lines of 'current cell - minus - value one cell left'
, rather than hardcoding $C4, $B4
etc each time?