Dear! I want previous cell to be formatted not the current cell.
If A3 contains "Present" only then format A2.
and Why VBA - Coz this is small part of my project, where as I have a VBA to do many several things & along with that code I need this to be added, VBA code is much appreciated!, thanks!