Forum Discussion
Re: conditional formatting based on content of another cell
Yes I know that but what I failed to mentions the first post was I need the "NO" to be Red and Bold and the "YES" to be Green and Bold.
1 Reply
Change the formula to
=IF(A2="", "NO", "YES")
Select B2:B100 or however far down you want.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'equal to' from the second drop down.
In the box next to it, enter the formula="NO"
Click Format...
Activate the Font tab.
Select Bold
Activate the Fill tab.
Select red as highlight color.
Click OK, then click OK again.Repeat these steps, but with
="YES"
and green as fill color.
