Forum Discussion
Conditional Formatting to Highlight Cells Based on Yes/No Values
In the work I am doing, I'm finding that having spreadsheets to manage specific data and responses to forms, both for analysis of frequent responses and tally of yes/no responses on forms, is excepti...
All you need is, select the range in column A:G say A2:G100 and make two New Rules for conditional formatting using the formulas given below.
For Yes (Green):
=$F2="Yes"
and set the format as per your choice.
For No (Red):
=$F2="No"
and set the format as per your choice.
In the attached I selected the range A2:G100 and make two New Rules for conditional formatting using the above formulas.
Please refer to the attached for more details.
Subodh_Tiwari_sktneer Thank you for answering with that very simple solution! I tried to do it without selecting the whole range the document will be using and it didn't work so I selected the range of cells to be included in the document and plugged in the formulae and it worked perfectly. Thank you again!