Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

A) Use =if() function to format the required numbers red

B) Apply Conditional Formatting command on Format menu

C) Select the cells that contain number between0 and100 then click Red color on Text Color tool

D) All of above

Microsoft Excel Microsoft Office ICDL
user-image
Question added by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
Date Posted: 2015/05/16
Upvote (2) Views (16) Followers (5) Answers (5) Report Question
Write an Answer
Register now or log in to answer.
Mohammad Basheer abu ahmad
by Mohammad Basheer abu ahmad , مشرف كمبيوتر ، الإشراف على الموظفين , قطاع عام

You can do that by used VB programming at MS office .... Option D) All of above

Gaavhshrhfh Bdbwebrhhth
by Gaavhshrhfh Bdbwebrhhth , IT Technician , Awal IT Solutions

In excel, when all the numbers between 100 and 199 in a range should be displayed in Red Color, applyFormatting command on Format menu d. All of these

Deviyani Kumari

Select the cell that contain number bteween 0 and 100 then click red colour on text color tool

hamza sirri
by hamza sirri , Senior Draughtsman , ADSSC

D) All of above//////////////////////////////////////

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

B) Apply Conditional Formatting command on Format menu

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help