Hi I have a spreadsheet with a list of names then 3 colums of yes/no drop down boxes in the next column I'd like the cells to either be red or green, where green means that the 3 preceding cells are all yes and red meaning that one of the three is a no, the list is getting quite long so this would make it a lot easier to see where the rows with all yes are.
Something like this:
If b2=Yes and c2=Yes and d2=Yes then fill=green else fill=red
Except I need it so Excel likes it lol
Green condition: =Countif(B2:D2,"yes")=3
Red condition:= =Countif(B2:D2,"yes")<>3
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi thanks for the info, that gives me true or false as to whether the 3 fileds have yes in them or not but what do I need to put in to get the cell colour to change green or red?
Cheers
Mark
You need to insert NBVC´s formula in the conditional format of the cell E2 and choose the colour you want.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
To apply the conditional formatting.Originally Posted by vanaaken
Select the cell you want to colour and go to Format|Conditional Formatting.
Select Formula Is from 1st drop down and enter the first formula. Click Format and choose colour from the Pattern tab. Click Ok.
In the main window, click Add and repeat for the other formula.
Cheers guys works great, will hopefully make things easier to spot!
Mark
You could also use these formulas within conditional formatting
=AND(B2:D2="Yes")
=OR(B2:D2<>"Yes")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks