| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data change color when entered 3 times
I was wondering if there was a way for a number to change color once it has
been entered three times into a spreadsheet. I just need a way to find out once I enter a number in three times that it will let me know, either a color change or anything. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data change color when entered 3 times
You could conditionally format a range of cells. Lets say you are entering
numbers in A2:A100. CF formula in cell A2 is: =COUNTIF($A$2:$A$100,A2)=3 Pick a format color. Copy to other cells in range as needed. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Sherie" wrote: I was wondering if there was a way for a number to change color once it has been entered three times into a spreadsheet. I just need a way to find out once I enter a number in three times that it will let me know, either a color change or anything. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Fill Color When Data is Entered | Excel Discussion (Misc queries) | |||
| Change color of cell when different cell has data entered | Excel Discussion (Misc queries) | |||
| Designating color in one cell based on data entered in another cel | Excel Worksheet Functions | |||
| change fill color in 2 cells when data entered in one | Excel Worksheet Functions | |||
| How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
Linear Mode
