ExcelBanter - conditional formatting

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

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

- - conditional formatting (https://www.excelbanter.com/excel-worksheet-functions/454695-conditional-formatting.html)

[email protected]

conditional formatting

I have x years and x months in a cell. How to highlight the cell when it is 5 year and x months?

MyVeryOwnSelf[_3_]

conditional formatting

I have x years and x months in a cell. How to highlight the cell
when it is 5 year and x months?

If there's a column of these values starting in A1, try selecting the column and using Conditional Formatting with the conditional formula
=LEFT(A1, 2)="5 "

All times are GMT +1. The time now is 12:41 AM.