![]() For fun, test your formats by changing some of the values in your range. It’s also pre-chosen the Light Red Fill with Dark Red Text, but as you can see, I have a few different styles to choose from:Ĭhoose whichever you like, and click OK. Here, I’ve chosen BETWEEN, and Excel has prefilled the two panels with 250 and 629. You now get a dialog box where you can enter more detail and choose a preset format. Under Highlight Cells Rules, you can see you can set a condition based on it being bigger or smaller than a given number, between two numbers, the same as another and so on. Select them, and click on Conditional Formatting, in the middle of the Home tab. Start off by entering a range of numbers between, say, into cells A1:A6. There are lots of useful preset conditional formats you can apply to your cells. You can also have multiple ‘layers’ of formatting in the same range. You can also have it responding to numeric values or text values. You can get it to highlight individual cells when they comply with the condition, or you can have the entire row highlight. This follows on quite logically from the IF statements ( logically! See what I did there? Groan □ ) because it’s formatting that only applies if a certain condition has been met. Saving your spreadsheets into other file formats. ![]() Merging cells, wrapping text, cell alignment and super/subscript. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |