Highlight current date
Cell range B3:B14 has conditional formatting applied, the formula checks if the date is today.
Conditional formatting formula:
A conditional formatting formula must evaluate to TRUE or FALSE or their equivalents any number or 0 (zero).
The TODAY function returns today's date. The equal sign compares the value to the date in cell B3 and returns TRUE or FALSE.
How to apply conditional formatting to a cell range
- Select cell range.
- Go to tab "Home"
- Click "Conditional Formatting" button.
- Click "New Rule..."
- Select "Use a formula to determine which cells to format"
- Type the formula in field "Format values where this formula is true:"
- Click "Format" button, then pick a formatting.
- Click OK button.
- Click OK button.
Highlight records based on date being today
Conditional formatting formula:
This CF-formula is applied to cell range B3:D12.
Highlight overlapping date ranges using conditional formatting
The image above demonstrates a conditional formatting formula that colors a record if there is at least one record that […]
Highlight records based on overlapping date ranges and a condition
adam asks: Hi, I have a situation where I want to count if this value is duplicate and if it […]
Highlight dates in a date range
Question: How do I highlight dates that meet criteria using conditional formatting? Table of contents Highlight values in a column […]
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.