I want to change the cell format on a spreadsheet I have set up when the cell goes below a fixed number.?

Question

I have done a spread sheet for work but It would benfit from the format of the cell i.e background, font changing when the quanity in the cell drops below 110 automatically. Please help

Answer 1

On the Tool bar go to Format - Conditional Formatting.

A box appears leave the first option as 'Cell Value' , select 'less than' from the second drop down box, into the third put 110.

Click on the format button and choose Font, background or pattern.

Hope ths helps

Answer 2

you need to make the format conditional

Select the cell
Click Format in the menu
Click Conditional Formatting

a small window opens

Cell value is - Less than - 110

Change the format (font, colour, etc) to your liking

Answer 3

On the format menu is a conditional formatting line, click that and fill in the details you want.

Answer 4

You need 'Conditional Formatting' under the Format menu. It's pretty self explanatory once you get in. Have a play with it!

Answer 5

right click on the cell, after format cell, at section number u can choose what u want, text if u want to write a text, number if u want to calculate something or the other options. good luck. i hope u talkin about excel.

Answer 6

use conditional formating