AnsweredAssumed Answered

Conditional Formatting

Question asked by fmpro_novice on Jul 15, 2013
Latest reply on Jul 16, 2013 by goodheart

Title

Conditional Formatting

Post

     Can someone tell me what the Conditional Formatting formula would be to do what is shown in the screenshot below? There are 18 boxes showing. If the number 15 is typed into the top left box, then box number 15 will be highlighted. If the number 1 is typed in, then the box number 1 will highlight, etc. 

     The top left box is a number field. And each of the 18 boxes are defined as number fields; ie., Box 1; Box 2; Box 3, etc.

     I know this should be really easy, sorry to be so dumb :)

     Thank you.

      

screenshot.jpg

Outcomes