Forms Controls

Highlight all amounts between 500 And 1600 # Show me all duplicates Show me only first occurences of duplicates FALSE Amount Names Names 256.33 $ Bill Bill 358.68 $ Fred Fred www.ozgrid.com 461.03 $ Jack Jack 563.38 $ Bill Bill 665.73 $ Harry Harry 768.08 $ Mary Mary 870.43 $ June June 972.78 $ Ned Ned 1,075.13 $ Mary Mary 1,177.48 $ Greg Greg 1,279.83 $ Joe Joe 1,382.18 $ John Kyle 1,484.53 $ Sam Sam 1,586.88 $ Paul Paul 1,689.23 $ Harry Harry 1,791.58 $ June Kyle 1,893.93 $ Dave Dave 1,996.28 $ Harry Kyle 2,098.63 $ Harry 2,200.98 $ Bill 2,303.33 $ 2,405.68 $ 2,508.03 $ 2,610.38 $ 2,712.73 $ 2,815.08 $ Select cells and go Format>Conditional Formatting to see how it works Choose Numbers....Select cells and go Format>Conditional Formatting to see how it works