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. |
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. . |
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. . |
All times are GMT +1. The time now is 03:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com