Conditional formating...??

[elmaco12]

Hi guys,

I have a workbook that looks like this:
A B C
1 Name Yes
2 Name
3 Name No
4 Name
5 Name Yes


What i would like to do is to look through Column B and C, and if the value in B is Yes the the whole row should be formated so the filling is green. If Column C is No, then the whole row should be formated with red filling. And if there is neither Yes or No, then do nothing...


how can i acchieve this??


thanks a lot...


EDIT: I see now that the webbrowser messes up my example.. but just think Column A = Names, Column B = Yes or blank, Column C = No or blank...

[elmaco12]

exactly! Thank you very much. Now when I see it i kinda need some modifications. Is it possible to change it so that the forumala only formates columns A through C ? And also, if column B contains Yes AND coulmn C contains No, the format will be yellow filling ?

EDIT:
I solved the A-C column issue, just by deleting the formating rules in all the other cells... but the Yes and No problem is still alive...

EDIT 2: Never mind, i solved it... Added a third rule that said =AND($B2=Yes;$C2="No") and the formated that one in yellow...

Thanks alot Stormseed for your help!