Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting in Macro
I want to use conditional formatting in a macro in such a way that the
entire row will be colored in Red instead of the single cell that contains the specific word. Please guide. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting in Macro
I would start by recording a macro that colours a complete row red. Then I would edit the macro, adding a line at the beginning something like: if cells(1,1) 500 then 10 else 20 line 10 is the start of the code that colours the row red, line 20 is END -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=561431 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting in Macro
Why, you can do that in CF Excel by selecting the whole row and use a
formula of =$C$1=value -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "shantanu oak" wrote in message ups.com... I want to use conditional formatting in a macro in such a way that the entire row will be colored in Red instead of the single cell that contains the specific word. Please guide. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting | Excel Worksheet Functions | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) |