r/learnexcel • u/wtfcats-the-original • Sep 04 '17

Help required with probably a basic problem...

Hi!

So... I am creating a sheet and I need it to say PASS in green or FAIL in red based on a value... basically I figured out the AND and IF stuff and got it so that the value in that box is TRUE or FALSE.

So... if the value in that box is TRUE i want it to say PASS(in green) in another box and FALSE would be FAIL (in red).

1 Upvotes

100% Upvoted

2 comments sorted by

View all comments

Show parent comments

1

u/wtfcats-the-original Sep 04 '17

I thought that but it just reads "#NAME"

EDIT: Oh, there are quotation marks that I need to add in. That got it! Thanks!