Sometimes you need to to be able to look at your spreadsheet and quickly see the row or column relate to a certain value. Conditional highlighting will definitely help with that. I will show using the current date as an example. Select the working range. Go to Conditional Formatting. Set the formula: The dollar sign ($) will anchor either a row (A$1) or a column ($A1), so that the formula will be applied to, respectively, all the columns in the anchored row or all the rows in the anchored column. Click Format and select the highlighting effects that you need. Click OK and observe the highlighted row or a column:
Comments
Post a Comment