software

I have a spreadsheet generated by an Access query being exported. It lists
names down the first column, then has 5 columns, some cells in these columns
are blank, some with quot;1quot; in them, some with quot;2quot;, some quot;3quot;, and some quot;4quot;.
I need to highlight cells with any number greater than 1, or any two
adjoining cells in a single row that have greater than or equal to quot;1quot; in
them.
I presume that this would require some sort of conditional formatting - I
can probably do the first but struggle with the 2 adjoining cells bit.
The other complication is that this spreadsheet is produced on a weekly
basis so it would be very useful if the process of highlighting could be
automated in a macro so we open the spreadsheet, run the macro and the
appropriate cells are highlighted.

The following condition will highlight all cells with the conditions
that you specified.

=OR(B2gt;1, AND(B2gt;=1, B3gt;=1))

To apply:

Select the 5 columns
Format|Codnitional Formatting...
Choose Formula Is
Enter the formula
CHoose the conditional format.

I am not aware that an import would reset all conditional formatting.
But if so, use the Macro Recorder (Tools|Macro|Record New Macro) before
you perform the above steps and reapply the recorder macro whenever
there is a new import.

HTH
Kostis Vezerides