Hello,
I have either "yes" or "no" text values in A1-D1
please advice how do I make next cell E1 to
1. turn green and fill the cell with text automatically "Done" if A1-D1 all "Yes"
2. turn red and fill the cell with text automatically "Not Done" if one of the A1-D1 text values is "No"
Thank you!
in E1 put
=IF ( COUNTIF(A1:D1,"yes")=4, "Done", "Not Done")
then for conditional formatting
you can use two rules
one for if the Cell = "done" turn green
and the 2nd for the cell "not Done" turn green
see attached spreadsheet example
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank you very much!!!
It helped!!
your welcome, thanks for the rep
Last edited by etaf; 02-23-2014 at 12:24 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks