"Taking the example used in the previous article ( Highlight entire row of Table Data ) I would like to know how to highlight a particular piece of data in that table, ie the intersection of a row and a column (one and a particular month in the example) " .
The solution is very similar to that shown in the previous post. We will have to include a new entry that references a month and use the logical AND within Conditional Formatting. The table from which we break is the same one you use in the previous article, namely:
To highlight a single datum in the model need to include a new data entry is the month. It introduces the name in E2 as shown in the picture and we move into the cell F2 menu and go to Data / Validation / Allow / List Source and select the range C10: N10 and click OK .
Now we can indicate the year and the month we want to highlight. Then select the range C11: N19 menu and go to Format / Conditional Formatting . In Condition 1 select Formula and in the right box write the following:
= Y ($ B11 = $ C $ 2, C $ 10 = $ F $ 2)
Press the button and choose Format, for example, frame number in bold yellow and click OK . The result is as follows:
really only highlighting the data in the table. To also highlight the year and month must do the following:
For the month:
1. Select the range C10: N10
2. menu go to Format / Conditional Formatting and select Formula .
3. In the right box write the formula: = C $ 10 = $ F $ 2
4. press the button and choose Format frame colors and font
5. press OK.
For the year:
1. Select the range B11: B19
2. menu go to Format / Conditional Formatting and select Formula .
3. In the right box write the formula: = $ B11 = $ C $ 2
4. press the button and choose Format frame colors and font
5. press OK.
0 comments:
Post a Comment