Does anyone know if its possible to format a row to be one color if no data is entered in it and then change to a different color once data is entered? This would be a quick way for me to reference when someone has changed data in my workbook.
Conditional formatting works but is there a way to expand the selection to cover the entire row? Like say I have text "Approved" in column F. If this says "not approved" I would like that whole row to turn red. Thanks for the help so far.