Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JimDerDog
 
Posts: n/a
Default Macro to highlight cells based on content

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default Macro to highlight cells based on content

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

=OR(B21, 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating links to cells with no content, but that have formatting cerah Excel Discussion (Misc queries) 1 January 25th 06 12:31 AM
how do I highlight an entire row based on the value of its content strider Excel Discussion (Misc queries) 1 December 16th 05 10:17 PM
locking cells based on results at runtime aken Excel Worksheet Functions 3 June 22nd 05 02:01 PM
Adding colour to a range of cells based on one of the cells v... McKenna Excel Discussion (Misc queries) 4 March 11th 05 03:25 PM
Put an autoshape in a cell based on another cells content Jo Excel Worksheet Functions 7 November 12th 04 05:34 PM


All times are GMT +1. The time now is 12:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"