Formula tool bar missing

I am rookie, but I cant find the formula toolbar only the conditional formatting.

Please help

Find more posts tagged with

Thank you. Could you help me with this question?

I dont even know where to start:

Column Stage Column Status Dropdown List

RED Ball Not Started

Green Ball In Progress

Yellow Ball Waiting

Blue Ball Completed

How and Where do I put in a formula to select from Status dropdown list Not Started and have

the Red Ball show up automatically in Column Stage?

I know this must be simple. But have no I idea where to start. Please help asap.

Schultis,

=IF([Status]23 = "Not Started", "Red")

for row 23

Be aware the if you manually change the Stage column to a different (or no) color, the formula will be overridden (and gone).

What you want is Nested If's for each drop down selection and its corresponding RYGB color.

See this article for help on Nested If's

Craig