Forum Discussion

dazgroves's avatar
dazgroves
Copper Contributor
Jul 27, 2023

Conditional Formatting

Hi all,

I’m not the sharpest at using excel but was wondering if somebody could help me with a formula so that i dont have to ‘whiten’ every required box when the job numbers on the left begin with a certain number. The numbers being either 53,54,71,72,61 or 62. 

Thanks in advance

 

excel
Excel for web

2 Replies

Sort By
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Jul 28, 2023

    dazgroves 

    This will do it. You need an array constant and a simple formula for the rule:

    Prefix  - defined name
={53;54;61;62;71;72}

Conditional Formatting Formula
=AND(XOR(LEFT($B2,2)*1=Prefix),C$1="Required")

     

  • mathetes's avatar
    mathetes
    Silver Contributor
    Jul 28, 2023

    dazgroves 

     

    You're far more likely to get a reply if you would post a copy of the spreadsheet itself, doing so on OneDrive or GoogleDrive with a link pasted here that grants edit access to the spreadsheet. In the absence of that, we would need to create a spreadsheet ourselves doing our best to copy your layout.

     

    So please help us help you by posting that copy...

Resources