"I have a table with historical sales data for months. The commonly used in presentations and help me select a high power one year, noted the information in this exercise " .
No problem. The solution is very simple (which is appreciated at this time of year) making use of Conditional Formatting . We start from the following example:
introduce data entry as follows:
We go to cell C2 menu and go to Data / Validation and select Enable / List . In paragraph Source select the range B11: B19 and click OK . In this way we have our list down over the years represented in the table:
Then select all the data in the table, ie the range C11: N19 (no labels). menu go to Format / Conditional Formatting and configure it as follows:
In Condition 1 select the option Formula and write the right box the formula:
= $ B11 = $ C $ 2
Press the button and select Format format in which you want to take the entire row to highlight (eg yellow frame and numbers in bold) and click OK :
Objective achieved! When you select a year in cell C2 entire row of the table for that year will be formatted as you have indicated:
0 comments:
Post a Comment