Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an expense manager spread sheet in Microsoft Excel 2010. A row contains (from B2 to AF) sequence of dates(from 1 to 31). How can I write formula field to highlight the current date cell. I tried Applies To =$A$5:$S$18, Formula =TODAY() but it does not work.

My excel sheet is look like enter image description here

share|improve this question
    
Have you tried using conditional formatting? –  assylias Apr 25 '12 at 11:49
    
@assylias Yes. With the Applies To and Formula –  Rauf Apr 25 '12 at 13:29
add comment

2 Answers

up vote 1 down vote accepted

This should work:

  • Select the range you want to highlight
  • Click on Conditional Formatting / Highlight Cells Rules / More rules
  • Rule Type: Format only cells that contain
  • Format only cells with: 1st box: Dates Occurring, 2nd box: Today
  • Click on the Format button to choose the formatting you want to apply

Alternatively, if you want to use a formula:

  • Select the range you want to highlight and note the cell that is selected within that range on the left hand side of the formula bar (typically the first cell of the range) - I assume it is B2 from now on, adjust accordingly.
  • Click on Conditional Formatting / New rule
  • Rule Type: Use a formula to determine which cells to format
  • Format values where this formula is true: =B2=TODAY() (don't forget the initial equal sign)
  • Click on the Format button to choose the formatting you want to apply
share|improve this answer
add comment

I can't be sure about your Applies To range without seeing your data (though it should certainly contain the cell that will be highlighted), but you need to change the Formula to

=A5=TODAY()

where A5 is the top-left cell in the range to which you want to apply the formatting. Just remember, conditional formatting formulas need to return a boolean value.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.