Basically the CF would be =AND($A1="yes",$A2="-") applied to the cell/range you need to color
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Last edited by Pecoflyer; 12-07-2017 at 01:12 AM.
|