Explore BrainMass
Share

Explore BrainMass

    Microsoft Excel Functions

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    For the data attached is it possible to make excel highlight (Yellow) rows of results that are over 500. I would like this to happen every time I enter a value > 500. I would also like a count at the top of the spreadsheet to display the number of times this happens for a Pre-op and an Operational.

    © BrainMass Inc. brainmass.com October 9, 2019, 7:57 pm ad1c9bdddf
    https://brainmass.com/computer-science/data/microsoft-excel-functions-134286

    Attachments

    Solution Preview

    Yes, both are possible. The first is done through conditional formatting.

    I will be referring to the spreadsheet often, so you can understand better

    Step 1: Highlight row 4 (first row of data) and go to Format -> Conditional Formatting
    Step 2: First drop down box should be Formula is. This option allows any cell in the spreadsheet to be used as a criterion for formatting. (The other option - Cell Value is - compares just that cell's value and formats it.)
    Step 3: We want column I to determine whether the row is highlighted, so enter "=$I4>500". ...

    Solution Summary

    The expert examines Microsoft Excel functions.

    $2.19