Search code examples
google-sheetsgoogle-sheets-formulaconditional-formattingtic-tac-toe

Conditional Formatting in Google Sheets isn't working

I'm trying to make a Tic Tac Toe game in a Google Sheets but I'm having trouble with the conditional formatting. I want the cell chosen by the computer to have a blue background/fill. Screenshot I tried the formula manually and it works, so I don't know what's wrong.

Solution

  • You can use the following formula

    =COLUMN()&","&ROW()=$H$2

    enter image description here