Yes Karen. A2:F2 could be highlighted with yellow through conditional formatting. Select A2:F2, in the ribbon of the Home tab, open Conditonal Formatting>Formula>type this formula in the box:
=($F2,"Yes")
Click Format>Fill>select yellow color>ok
Again, this is a cellphone so I am not sure if the formula works okay.
Edit: The formula should be:
=($F2="Yes")
Last edited by Marcia; 03-07-2020 at 07:00 AM.
|