apparently I need
Hi, please check out my spreadsheet. I appreciate it if any one of you geniuses can help me out as I cant figure how to do this
Download from the above link.....Sheet1 is what I am interested in having the formula do
It would look up all the divided values and find if any are within 0.2 of each other and highlight the matches different colours from other matches.
Thankyou all in advance
apparently I need
a few
more posts
to post my attachment
Here is the spreadsheet
http://www.filedropper.com/showdownload.php/sfexcel
thankyou
Can you attach your file in the forum directly using the forum tools (Go Advanced - paperclip icon) or through a non-subscription site like dropbox or skydrive.
need to remove /showdownload.php from middle of OP's link to get file.
Thanks NoS
wowsers, please try selecting D3:X27 and apply conditional formatting using "use a formula to determine which cells to format", then insert formula:
=AND(D3<>"",COUNTIFS($D$3:$X$27,">="&D3-$AA$1,$D$3:$X$27,"<="&D3+$AA$1)>1)
where AA1 contains the factor you are looking for (e.g. 0.2)
You can change the factor to observe different results.
Bookmarks