In one column of a spreadsheet I want to highlight the first cell ONLY above a specific number. For example, if a column has values increasing from 0 in the first row to x in the last row, how do I highlight the first cell ONLY in that column that is greater than a certain value. It can't be a specific cell either because the spreadsheet is formulated to change the values in each row based on previous rows.
Basically I want Excel to identify and highlight the first cell ONLY in a column greater than or equal to a certain value regardless of how many rows are being used.
No comments:
Post a Comment