Microsoft Excel - Conditional Formating
Asked By marlene
08-Sep-10 10:54 AM
how do i do conditional formatting for average total lower than 80%??
Venkat K replied to marlene
Follow the below steps to do the conditional formatting:
- Select the cell or the relevant range of cells to be formatted (here in you case select the cell range where you display average range)
- On the Home tab Click “Conditional Formatting“.
- Choose New Rule, select a rule type and edit the rule description.
Here you can specify the condition in this rule saying that the value > 80 then mention what format change you need.
Thanks,
Awais Ali replied to marlene
please attach the excel file or screenshot of the file so we can guide you.
Microsoft Excel Excel I am quite impatient and would like to watch a tutorial on excel that takes one through the basics to advanced spreadsheet management. soes such a thing exist? - - ken Excel New Users Discussions Microsoft Excel (1) Excel 2007 (1) Excel 2003 (1) Charts (1) Office (1) Union (1) Page (1) AggieBelieve (1
Non synchronisation in split screens in Microsoft Excel Excel Lotus 123 has the ability to split a worksheet in two, similar to Microsoft Excel, but in Lotus 123 you have the ability to scroll down one side whilst the other side remains stationary. Can you do that in Microsoft Excel and if so how? Excel Miscellaneous Discussions Microsoft Excel (1) Worksheet (1) Workbook (1) VB (1) Normek (1) Lotus (1
does this group allow c# questions(re excel) Excel Are c# - --> excel questions off topic here? Thanks mark Excel Discussions Microsoft Excel (1) Probably more appropriate to post over in the excel.programming group but most regulars monitor all groups so give it a shot there or
In Case You Didn't Notice - MS Released Patch RE:Excel Excel http: / / support.microsoft.com / kb / 980150 - - Regards, RD - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Please keep all correspondence within the Group, so all may benefit ! - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Excel Miscellaneous Discussions Microsoft Excel (1) Excel (1) GovierRagDyeR (1) RegardsRoger (1) RickThanks (1) Correspondence (1) Semblance (1) WELLLL (1) Have you
Excel 2007 Taskbar Tab shows Icon + "Microsoft Excel - filename" Excel Windows Vista Bus / Excel 2007: How do I show just the filename on my Excel taskbar tabs? My taskbar shows [Excel Icon] "Microsoft Excel - Filename1", with multiple tabs on my taskbar I typically can't see which "Filename