Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating links to cells with no content, but that have formatting | Excel Discussion (Misc queries) | |||
how do I highlight an entire row based on the value of its content | Excel Discussion (Misc queries) | |||
locking cells based on results at runtime | Excel Worksheet Functions | |||
Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) | |||
Put an autoshape in a cell based on another cells content | Excel Worksheet Functions |