| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting if a certain condition is met
I want to use Conditional Formatting to change the row color at each change
in a value. In the same way sub-totals work. For example, at each change in the EE ID it would change the row high-lighting. EE ID LAST NAME 003461 CARSON 003462 SMITH 029800 JONES 004590 HOWARD 004590 HOWARD 029925 BALDWIN 010767 KELLY 010767 KELLY 010767 KELLY 024323 ROBINS 027205 EDWARDS |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting if a certain condition is met
Select A3 and pull-down:
Format Conditional Formatting Formula is and enter: =A2<A3 then set the hilight color. Then copy the format down the column. repeat this for B3, C3, etc. -- Gary''s Student - gsnu200735 "JerryG" wrote: I want to use Conditional Formatting to change the row color at each change in a value. In the same way sub-totals work. For example, at each change in the EE ID it would change the row high-lighting. EE ID LAST NAME 003461 CARSON 003462 SMITH 029800 JONES 004590 HOWARD 004590 HOWARD 029925 BALDWIN 010767 KELLY 010767 KELLY 010767 KELLY 024323 ROBINS 027205 EDWARDS |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting if a certain condition is met
This will not work as I want the name Howard and Kelly all to be the same
color, but I also need it to alternate row colors when a change occurs. Thanks for the help. -- JerryG "Gary''s Student" wrote: Select A3 and pull-down: Format Conditional Formatting Formula is and enter: =A2<A3 then set the hilight color. Then copy the format down the column. repeat this for B3, C3, etc. -- Gary''s Student - gsnu200735 "JerryG" wrote: I want to use Conditional Formatting to change the row color at each change in a value. In the same way sub-totals work. For example, at each change in the EE ID it would change the row high-lighting. EE ID LAST NAME 003461 CARSON 003462 SMITH 029800 JONES 004590 HOWARD 004590 HOWARD 029925 BALDWIN 010767 KELLY 010767 KELLY 010767 KELLY 024323 ROBINS 027205 EDWARDS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting 4th Condition | Excel Worksheet Functions | |||
| How to combine more than one condition for CONDITIONAL FORMATTING | Excel Discussion (Misc queries) | |||
| 4 condition conditional formatting | Excel Worksheet Functions | |||
| conditional formatting - multiple condition | Excel Discussion (Misc queries) | |||
| conditional formatting under a condition... | Excel Programming | |||
Linear Mode
