I am trying to use condictional formating for duplicate values in columns for numbers just between 252 - 374, nothing else.
I am trying to use condictional formating for duplicate values in columns for numbers just between 252 - 374, nothing else.
Last edited by Nunzio; 07-20-2014 at 06:35 PM. Reason: I fixed the problem
you could use a COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)>0 will give you the duplicates
=Countifs( range, ">=252", range, "<=374")>0
use in a conditional formatting formula
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
The range I am using is =$C:$I and I was not able to get the condictional formula to work?
I don't want to count the number of duplicates I want both duplicates beween 252 & 374 to be condictionally formatted.
thats not a count - its a logical test to see if the count is greater than zero and so a duplicated value
try loading a sample spreadsheet
you could just use
=AND( C1>=253, C1<=374)
and appy to C:I
Even Weeks Schedule Template.xlsx I want to show the doubles for 252 - 374.
I should have clarified for each day of the week.
Both methods seem to show each individual value between 252 -374 rather than just highlighting the duplicates.
my office 2010 PC has broken today - so i cant test
try
=Countifs( range, ">=252", range, "<=374")>1
This formula is looking for and number two of the numbers listed within the range, it could be 252 and 374 and register as a double, I need it just to show doubles of the same number twice within the min max of 252 -374. Example 252 and 252 are a duplicate. Thanks
sorry, i will have to wait and get excel going againmy office 2010 PC has broken today - so i cant test
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks