Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
Date de publication: 2015/05/16
Mohammad Basheer abu ahmad
par Mohammad Basheer abu ahmad , مشرف كمبيوتر ، الإشراف على الموظفين , قطاع عام

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

Gaavhshrhfh Bdbwebrhhth
par 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

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

hamza sirri
par hamza sirri , Senior Draughtsman , ALTERATH ENGINEERING CONSULTANTS

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

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

B) Apply Conditional Formatting command on Format menu

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?