Macro to highlight cells based on content

[Guest]

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 "1" in them, some with "2", some "3", and some "4".
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 "1" 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.

 

[vezerid]

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

=OR(B2>1, AND(B2>=1, B3>=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