ExcelBanter - Conditional Format to highlight rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional Format to highlight rows (https://www.excelbanter.com/excel-worksheet-functions/257574-conditional-format-highlight-rows.html)

Jack Deuce

Conditional Format to highlight rows

Column A is not formatted as a date but does contain the year and
month as 2010 03. How can I use Conditional Formatting to highlight
that row when it is the current month and current year?

thanks to all...

David Biddulph[_2_]

Conditional Format to highlight rows

Use the formula
=AND(--LEFT(A2,4)=YEAR(TODAY()),--RIGHT(A2,2)=MONTH(TODAY())) as your
condition.
Or =AND(--LEFT($A2,4)=YEAR(TODAY()),--RIGHT($A2,2)=MONTH(TODAY())) if you
want to highlight the whole row.
--
David Biddulph

"Jack Deuce" wrote in message
...
Column A is not formatted as a date but does contain the year and
month as 2010 03. How can I use Conditional Formatting to highlight
that row when it is the current month and current year?

thanks to all...

Teethless mama

Conditional Format to highlight rows

CF:

=DATE(LEFT(A1,4),RIGHT(A1,2),1)=DATE(YEAR(TODAY()) ,MONTH(TODAY()),1)

"Jack Deuce" wrote:

Column A is not formatted as a date but does contain the year and
month as 2010 03. How can I use Conditional Formatting to highlight
that row when it is the current month and current year?

thanks to all...
.

All times are GMT +1. The time now is 02:53 PM.