Conditional Formatting: highlight the last cell in a row containing data

[bldr123]

I understand how to set con. formatting to highlight a cell based on perameters, how do I then "de-highlight" the cell when the cell next to it has data input (this subsequent cell would then be highlighted).


Any help would be appreciated.


Thanks

 

[Faseeh]

Hi bldr123,


Welcome to the forums!!! Is this that you wanted:


http://dl.dropbox.com/u/60644346/bldr123_sample.xlsx


Regards,

Faseeh

 

[Luke M]

You could do some sort of AND statement. For cell A2, might be:

=AND(B2="",A2>0)