When would you use conditional formatting on a cell? You want to highlight negative numbers by using red text. You want to use a formula and function to sum the values in a column You want to change the font for every cell in the spreadsheet. ) You want to hide the contents of a column.

Conditional formatting is a feature in spreadsheet programs like Microsoft Excel and Google Sheets that allows you to dynamically format cells based on their contents or the values they contain. In this case, the correct answer is: You want to highlight negative numbers by using red text. This is because conditional formatting can be used to change the appearance of cells that meet certain criteria, such as highlighting negative numbers in red. The other options are not correct because they do not describe the use of conditional formatting. Summing values in a column, changing the font for every cell in the spreadsheet, and hiding the contents of a column are all tasks that can be accomplished without using conditional formatting.