I'm looking to apply conditional formatting based on the value of another cell in Excel. Navigate to the 'Conditional Formatting' category page. From there, find and click on the article titled 'Conditional Formatting Based on Another Cell'. Once on the article page, identify and state the main Excel versions this tip applies to.
Navigate to the homepage of ExcelRibbon.Tips.Net (https://excelribbon.tips.net/index.html). Click on the 'Formatting' link under 'Main Excel Topics' (ID 53). On the 'Formatting' page, locate and click on the 'Conditional Formatting' category link (ID 93 from the previous search results, or its equivalent on the Formatting page if IDs change). On the 'Conditional Formatting' category page, locate and click on the article link titled 'Conditional Formatting Based on Another Cell'. Once on the 'Conditional Formatting Based on Another Cell' article page, identify the Excel versions this tip is applicable to. State the Excel versions this tip applies to.
The agent successfully navigates to the 'Formatting' main topic page. The agent successfully navigates to the 'Conditional Formatting' category page. The agent successfully navigates to the 'Conditional Formatting Based on Another Cell' article page. The agent states that the tip applies to 'Excel 2007, 2010, 2013, 2016, 2019, and 365'.