Hi there
In the sheet "Test", column D (D2-D14) are this formula:
=IF(VLOOKUP(C2,'どうし (―ます) Beginner (Verbs)'!A3:B150,2,FALSE)=B2,"correct","try again")
Is it possible to make the "try again" text prompt in red?
Hi there
In the sheet "Test", column D (D2-D14) are this formula:
=IF(VLOOKUP(C2,'どうし (―ます) Beginner (Verbs)'!A3:B150,2,FALSE)=B2,"correct","try again")
Is it possible to make the "try again" text prompt in red?
Last edited by randomcow; 01-31-2013 at 10:57 PM.
Conditional formatting, see attached.
Perfect!
Thank you, ref added
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks