Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to get the cells in Excel become automatically highlighted with yellow after typing "1" in those cells?

Microsoft Excel
user-image
Question added by Arslan Atayev , Training Coordinator , Dragon Oil (Turkmenistan) Ltd.
Date Posted: 2017/11/13
Upvote (0) Views (2) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Firas Shahadi
by Firas Shahadi , Human Resources Director , SAUDI UNION

I think the best way is to use Conditional Formatting.

You can use may conditions that check the cell content and apply formatting accordingly.

 

Cheers

 

Write Your Answer
More Questions Like This