Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Do You Turn A Partial Row Of Sheet Cells A Color From A UserForm
Greetings,
I am using a UserForm to enter data into a series of sheets labeled by month and year. When I hit the save button, the data that I entered into the UserForm is transported to the bottom of the correct sheet, then sorted. The UserForm then cycles, closing then reopening (resetting everything). My problem is that I have used up the three conditions under Conditional Formatting and need to color the row that I just pasted. I am not sure what is the best way to do this. Any help would be most appreciated. TIA -Minitman |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Do You Turn A Partial Row Of Sheet Cells A Color From A UserForm
http://xldynamic.com/source/xld.CFPlus.Download.html
-- HTH Bob Phillips "Minitman" wrote in message ... Greetings, I am using a UserForm to enter data into a series of sheets labeled by month and year. When I hit the save button, the data that I entered into the UserForm is transported to the bottom of the correct sheet, then sorted. The UserForm then cycles, closing then reopening (resetting everything). My problem is that I have used up the three conditions under Conditional Formatting and need to color the row that I just pasted. I am not sure what is the best way to do this. Any help would be most appreciated. TIA -Minitman |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Do You Turn A Partial Row Of Sheet Cells A Color From A UserForm
Hey Bob,
This looks really cool!!!! Thanks. -Minitman On Sun, 17 Jul 2005 09:38:28 +0100, "Bob Phillips" wrote: http://xldynamic.com/source/xld.CFPlus.Download.html -- HTH Bob Phillips "Minitman" wrote in message .. . Greetings, I am using a UserForm to enter data into a series of sheets labeled by month and year. When I hit the save button, the data that I entered into the UserForm is transported to the bottom of the correct sheet, then sorted. The UserForm then cycles, closing then reopening (resetting everything). My problem is that I have used up the three conditions under Conditional Formatting and need to color the row that I just pasted. I am not sure what is the best way to do this. Any help would be most appreciated. TIA -Minitman |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Do You Turn A Partial Row Of Sheet Cells A Color From A UserForm
Hey Bob,
I tried to use the CFP Add In and I could not copy the first row down. I placed the same two conditions into 23 cells on the 2nd row. So far, so good. I tried to use the Copy Format choice under the Special Function choice in the CFP menu item. This is where it got weird! Some of the cells copied ok. But there does not seem to be any consistency as to how the formats copy. sometimes the cell numbers advance and sometimes they don't! What am I lacking???? The two conditions are as follows: =AND('Jan-94'!C2="", 'Jan-94'!H2="Callahan, Nancy") <This turns the cell Yellow =AND('Jan-94'!C2="", NOT('Jan-94'!H2="")This one turns the cell a light Purple. Anyone have any ides as to how to fix what it is that is wrong Any help is appreciated. TIA -Minitman On Sun, 17 Jul 2005 03:51:18 -0500, Minitman wrote: Hey Bob, This looks really cool!!!! Thanks. -Minitman On Sun, 17 Jul 2005 09:38:28 +0100, "Bob Phillips" wrote: http://xldynamic.com/source/xld.CFPlus.Download.html -- HTH Bob Phillips "Minitman" wrote in message . .. Greetings, I am using a UserForm to enter data into a series of sheets labeled by month and year. When I hit the save button, the data that I entered into the UserForm is transported to the bottom of the correct sheet, then sorted. The UserForm then cycles, closing then reopening (resetting everything). My problem is that I have used up the three conditions under Conditional Formatting and need to color the row that I just pasted. I am not sure what is the best way to do this. Any help would be most appreciated. TIA -Minitman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off gridline in partial Excel worksheet | Excel Discussion (Misc queries) | |||
Partial Text Color Change in Cell | Excel Discussion (Misc queries) | |||
Having 10 cells with the highest number turn color | Excel Discussion (Misc queries) | |||
Partial font color | Excel Discussion (Misc queries) | |||
Clicking cells on sheet creates Text Box. How do I turn this off? | Excel Discussion (Misc queries) |