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"
- Press with left mouse button on "Conditional Formatting" button.
- Press with left mouse button on "New Rule..."
- Select "Use a formula to determine which cells to format"
- Type the formula in field "Format values where this formula is true:"
- Press with left mouse button on "Format" button, then pick a formatting.
- Press with left mouse button on OK button.
- Press with left mouse button on OK button.
Highlight records based on date being today
Conditional formatting formula:
This CF-formula is applied to cell range B3:D12.
Cf dates category
This article demonstrates event code combined with Conditional Formatting that highlights overlapping date ranges based on the selected date range. […]
Question: How do I highlight dates that meet criteria using conditional formatting? Table of contents Highlight values in a column […]
Color odd months Conditional formatting formula: =MOD(MONTH($B6),2) Explaining CF formula in cell B6 Step 1 - Calculate number of month The […]
Functions in this article
More than 1300 Excel formulas
Conditional Formatting categories
Excel categories
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.