Something

<?$your_variable='$return_from_db_query';if ($your_variable='no'){?><span style="color:red"><?echo $your_variable ?></span><? }else { ?><span style="color:green"><?echo $your_variable?></span><? }// -- Better to sub red and green for hex color codes though.