Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Font Color meeting an argument
I have a column with numbers, these numbers are unique,
is there a way to write into a formula that if a number repetes the color of the numbers turn red. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Font Color meeting an argument
You could use comditional formatting. Select your range. I will assume a1:a6 for the example. Under format conditional formatting, choose "formula is" and write: =COUNTIF($A$1:$A$6,A1)1 set your pattern or font to color your dupes Lance -----Original Message----- I have a column with numbers, these numbers are unique, is there a way to write into a formula that if a number repetes the color of the numbers turn red. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Font Color meeting an argument
.... and
if you only want to highlight previous instances of the repeat, that is not the final repeat, use =COUNTIF(A1:$A$6,A1)1 or ignore the first instance, use =COUNTIF($A$1:A1,A1)1 -- HTH Bob Phillips "Lance" wrote in message ... You could use comditional formatting. Select your range. I will assume a1:a6 for the example. Under format conditional formatting, choose "formula is" and write: =COUNTIF($A$1:$A$6,A1)1 set your pattern or font to color your dupes Lance -----Original Message----- I have a column with numbers, these numbers are unique, is there a way to write into a formula that if a number repetes the color of the numbers turn red. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing font color if conditions are met | Excel Worksheet Functions | |||
Font color changing by itself | Excel Discussion (Misc queries) | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
Changing Font Color | Excel Discussion (Misc queries) | |||
can i use format (font color) in an if argument? | Excel Discussion (Misc queries) |