In the Format Cells dialog box. You can press Ctrl - 1 to access it. Amongst the tabs in it you will find ones for changing borders and shading cells.
Yes, you can do all sorts of formatting in a spreadsheet, including borders and shading.
Yes. They are part of the formatting options. You can use the Border options and the Fill options for this purpose. Press Ctrl - 1 to access the Formatting options.
Background styles
Table Style
by shading in one box an one unshaded
Question cont..... Ok so I have the basics sorted, what i need help with is the conditional formatting. I want to format each answer so that the whole word needs to be correct before it will change the shading to indicate a correct answer. I know how to do the basic formatting where each letter changes shading if correct. Anyone that can help please?
A shading coil induces currents to create an additional electrical phase. The coil pauses slightly to control magnetic flux. Delaying magnetic flux allows for a secondary rotating magnetic field to build.
Brown shading on a physical map typically represents topographic features such as high land or mountains. This shading is used to indicate areas of elevation and terrain relief, helping viewers understand the landscape of the area being depicted.
shading graphics
You need to use Conditional Formatting to do that. You need to set a formula option within Conditional Formatting for the cells that look at one particular cell's value. Conditional Formatting has the option to set formatting based on values or based on formulas. In this instance you would need a formula. For example you could have a formula like this, which checks if cell A2 is greater than 10:=$A$2>10Then you can set whatever formatting you want.
is shading in one direction
is shading in one direction