Conditional formatting upon another cell

by Vaibhav Johari   Last Updated April 16, 2018 07:01 AM

I want to enter the text in a cell, but its depend upon another cell value formatting. example:

In A1 value is "Vaibhav" and if I will make it in bold(Ctrl+B), then automatically the next consecutive cell value will come as "Present", else will come as "Absent".

vaibhav present

reena absent

rahul present

vijay present

nikita absent

Related Questions

If Function is not working in Excel

Updated May 31, 2016 09:00 AM