Hi Brandon,
To create an
IF function with
YES/NO and
color fill, you can follow these steps:
- Select the cell where you want to apply the IF function.
- Click on the "Conditional Formatting" option in the "Home" tab of the Excel ribbon.
- Select "New Rule" from the drop-down menu.
- In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format."
- In the "Format values where this formula is true" field, enter the following formula for green color fill:
Formula:
=IF(I3="YES",TRUE,FALSE)
- Click on the "Format" button and select the "Fill" tab.
- Choose the green color you want to use and click "OK."
- Click "OK" again to apply the formatting rule.
To apply the
red color fill for
"NO", repeat the above steps, but use the following formula in step 5:
Formula:
=IF(I3="NO",TRUE,FALSE)
and choose the
red color in step 7.