1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • conditional formatting

    From jiayuan.goh@gmail.com@21:1/5 to All on Mon May 18 07:59:05 2020
    I have x years and x months in a cell. How to highlight the cell when it is 5 year and x months?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From MyVeryOwnSelf@21:1/5 to All on Mon May 18 12:07:32 2020
    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 "

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)