automatic will highlight the names

Hi!
Would like to asked for help.
I'm trying to create work sheet to monitor the status of our employees.
I used conditional formatting but i cant make it.
what I'm trying to do every time I put it in "Active" it will highlight the name with
Yellow and "Inactive" with color red.


Thank you!


Kind regards,
April

Hi Aries_01463,

Please see attached. I made the cell value red or yellow depending on the status. If you wanted the FONT (the letters) to change color then you can edit the conditional formatting and make the font color change not the fill in color.

Thanks.

If you don't mind Mr.HiB kindly please tell me how did you make it?
Just want to try it to my other worksheet.

Thanks a lot.

Go to conditional formatting, click on new rules. Go to "Format only cells that contain", change the between to equal to and type in Active, set the format to yellow so it highlights yellow whenever someone has Active. Repeat the process but make it equal Inactive and have it highlight red.

The other way you can do this is "Use a formula to determine which cells to format" and then you could simply do =[ref cell]="Active" then copy and paste the conditional formatting to the other cells.

Thanks a lot.

You're welcome!