Thread: conditional formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_3_] MyVeryOwnSelf[_3_] is offline
external usenet poster
  
Posts: 56
Default 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 "
Reply With QuoteReply With Quote