Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditionnal formatting using VB
That would mean checking Column B (column 2) and using offset
to color the cell to the left. My page on Event macros is http://www.mvps.org/dmcritchie/excel/event.htm Presuming that this is a manual change to a cell in B you would use an Event Change macro. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Sherif" wrote in message ... I forgot to mention that my formatting on cell A depends on a value in cell B... I don't know if this makes any difference as I was reading it can be done using Worksheet Change Event Macro... Thx a lot "Sherif" wrote: I need to apply some conditional formatting to my Sheet, however by using the preset function I can only apply up to 3 different formattings, I need more, how can I do it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditionnal formatting using VB
It's manually entered, and yes it works.
--- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Sherif" wrote in message ... What about if the value in Column B is from a Data Validation list of values? Will the Event macro still work? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionnal Formatting | Excel Worksheet Functions | |||
How to create icon sets for excel 2007 conditionnal formating ? | Excel Discussion (Misc queries) | |||
How to program a macro to hide rows with conditionnal formating | Excel Discussion (Misc queries) | |||
Conditionnal formatting using VB | Excel Programming | |||
Formula... conditionnal format | Excel Programming |