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

user-image
Question added by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
Date Posted: 2015/05/16
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

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

More Questions Like This