Conditional Formatting to Highlight Cells Based on Yes/No Values

Gabz_122  just a little to explain how custom formulas in conditional formatting work and what Subodh_Tiwari_sktneer  did.  A conditional formatting will apply the requested format to any cell that evaluates as "True" (which is anything except False or 0).  When you create the formula you need to create the cell reference(s) in the formula based on the 1st upper left cell in the range(s) that you select.  So in Subodh's example that is A2.  Since you want to use column F you use $F2 because the $F will "Fix" that reference to always be column F and the 2 (without a leading $) will adjust the row for every cell the condition formatting looks at (in this case to be the same row as the cell being evaluated since the upper left cell A2 and $F2 are both in row 2).  So as the conditional formatting goes cell to cell it will always look to compare the value in column F of the same row to determine if it evaluates True or False.

I hope that helps you understand conditional formatting rules.