Value-based shading(Excel 2007)

              Differentiate between data without sorting it with the help of Conditional Formatting.

              If you need to differentiate between data with out sorting it, you can do it with ease in Excel 2007. Using the Conditional Formatting rules in Excel 2007, you can easily segregate even numbers from the odd numbers in your data. First select the cells with the data values, then go to the ‘Home tab’. Here under the ‘Styles’ group, select ‘Conditional Formatting’. In the dropdown list click ‘Manage Rules’ and then select ‘New Rule’. You will be asked to ‘Select a Rule Type’, here choose the ‘Use a Formula to Determine Which Cells to Format’ option. In the ‘Format Values Where This Formula Is True’ textbox, enter the formula as "=MOD(A1,2)-1" and select ‘Format’. Then click on the ‘Fill’ tab in the ‘Format’ dialog box and select the color yellow, press ‘Ok’ to continue. Then go back to the ‘Conditional Formatting Rules Manager’ and select ‘New Rule’. In the ‘Format Values Where This Formula Is True’ textbox, enter the formula as "=MOD(A1,2)-0" and select ‘Format’. Then click on the ‘Fill’ tab in the ‘Format’ dialog box and select the color orange, press ‘Ok’ to continue. Click ‘OK’ to apply the conditional formatting to the selected cells.