| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
format records (color) at each change in continious field
You're welcome!
-- Biff Microsoft Excel MVP "MRGREEN" wrote in message ... Thank you ver much MR Green "T. Valko" wrote: I should note that this formula is based on each group being unique. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... This will work as long as there are no empty cells within your range. This might affect performance if you have 1000's of rows. Assume your data is in the range A1:C100 Select the range A1:C100 Goto FormatConditional Formatting Formula Is: =MOD(ROUND(SUMPRODUCT(($A$1:$A1<"")/COUNTIF($A$1:$A1,$A$1:$A1)),0),2) Click the Format button Select the Patterns tab Select the desired color OK out -- Biff Microsoft Excel MVP "MRGREEN" wrote in message ... I want to toggle the color of the background for all the rcords at each change of value in a specified field |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the font color using the Time format in a formula | Excel Discussion (Misc queries) | |||
| How do you use conditional format to change a bar color on a char. | Charts and Charting in Excel | |||
| How do I make a formula to have the color change in a field? | Excel Discussion (Misc queries) | |||
| How do I change the format/cell/border/automatic color to black | Excel Discussion (Misc queries) | |||
| format cell to change color when copied | Excel Discussion (Misc queries) | |||
Threaded Mode
