Conditional format of B use Formula is. =A1=X so if A is equal to X then
format the font color of b.

Rachael wrote:

I was just trying this out, and i don't know how to make is so that if the
answer in cell A is X then the format of cell B is Y type thing. Conditional
formatting doesn't seem to work that way....

"Bob I" wrote:


Perhaps use Conditional Formatting to reveal(set font color black) the
next clue when the correct entry is placed in the "answer cell", and so
on to the next,

Rachael wrote:


Hello. I want to set up a simple locked down spreadsheet for a treasure hunt.
I want there the be an initial cell on the screen with a clue. I want there
to be some kind of button where they can click and put in a password/answer
and then the next cell will populate with the next clue.
I'm a novice user of excel - fine for basic tables and some forumlas, but
that's it.
I need to make this spreadsheet for work for next week (so, finishing it
this weekend for Monday) for International Talk Like a Pirate Day (Sept.
19th). Thanks!!