Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating??
I have tried to do this several different way and can not find and easy way to do it. Item # MFG Desc. 150940 BS 295/75R22.5/14 M725 Highlighted 150940 BS 295/75R22.5/14 M725 Highlighted 150940 BS 295/75R22.5/14 M725 Highlighted 150991 BS 285/75R24.5/14 M725 Not Highlighted 150991 BS 285/75R24.5/14 M725 Not Highlighted 151300 BS 315/80R22.5/20 M843 EC DRV Highlighted 151300 BS 315/80R22.5/20 M843 EC DRV Highlighted 151300 BS 315/80R22.5/20 M843 EC DRV Highlighted 152498 BS 265/70R19.5 M729 14P Not Highlighted 152935 BS 11R22.5/14 M725 AZ TL ST Highlighted Any time the item # changes then it alternates between shaded and not shaded, any ideas? Thanks for the help -- mizunobill ------------------------------------------------------------------------ mizunobill's Profile: http://www.excelforum.com/member.php...o&userid=33614 View this thread: http://www.excelforum.com/showthread...hreadid=533936 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating??
I have posted an example using conditional formatting to
http://cjoint.com/?esxz752EI1 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "mizunobill" wrote in message ... I have tried to do this several different way and can not find and easy way to do it. Item # MFG Desc. 150940 BS 295/75R22.5/14 M725 Highlighted 150940 BS 295/75R22.5/14 M725 Highlighted 150940 BS 295/75R22.5/14 M725 Highlighted 150991 BS 285/75R24.5/14 M725 Not Highlighted 150991 BS 285/75R24.5/14 M725 Not Highlighted 151300 BS 315/80R22.5/20 M843 EC DRV Highlighted 151300 BS 315/80R22.5/20 M843 EC DRV Highlighted 151300 BS 315/80R22.5/20 M843 EC DRV Highlighted 152498 BS 265/70R19.5 M729 14P Not Highlighted 152935 BS 11R22.5/14 M725 AZ TL ST Highlighted Any time the item # changes then it alternates between shaded and not shaded, any ideas? Thanks for the help -- mizunobill ------------------------------------------------------------------------ mizunobill's Profile: http://www.excelforum.com/member.php...o&userid=33614 View this thread: http://www.excelforum.com/showthread...hreadid=533936 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating??
I think you need an additional column on which to base the flag if the new column is B set the first value to true then a formula of =IF(A2=A3,B2,NOT(B2)) use this result to drive the conditional formatting hope this helps. I suspect there is a cleaner way. -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=533936 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating??
I don't think I explained what I am trying to do. Your formula just indicates the first row when a part number changes. I want to have all of the same part numbers one color and then when the number changes then it switches color. I tried to indicate this, if you look at the far right column it say highlighted or not highlighted this would indicate colored or not colored. I have sent an attachment of what it should look like. -- mizunobill ------------------------------------------------------------------------ mizunobill's Profile: http://www.excelforum.com/member.php...o&userid=33614 View this thread: http://www.excelforum.com/showthread...hreadid=533936 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating??
It should block the groups of same values with a true or false value The TRUE in the example is in cell B2 1 TRUE result true 1 =IF(A2=A3,B2,NOT(B2)) result true 2 =IF(A3=A4,B3,NOT(B3)) result false 2 =IF(A4=A5,B4,NOT(B4)) result false 3 =IF(A5=A6,B5,NOT(B5)) result true 3 =IF(A6=A7,B6,NOT(B6)) result true 4 =IF(A7=A8,B7,NOT(B7)) result false regards -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=533936 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel conditional formating decimal fractions | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) |