| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlite the cell if above 5:31
Hello from Steved
Is it possble to highlite the cel in Col A with the color yellow if it is above 5:31 please Thankyou. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Highlite the cell if above 5:31
Is it possble to highlite the cel in Col A with the color
yellow if it is above 5:31 please Select your range or the entire column and click Format / Conditional Formatting... on Excel's menu. On the dialog box that appears, set the first drop-down field to "Cell Value Is", set the second drop-down field to "greater than" and type 5:31 in the third field. Now click the Format button and select the highlight color you want from the Patterns tab and OK your way back to the spreadsheet. That is it.. any cell having a time greater than 5:31 will be shaded in the color you selected. Rick |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Highlite the cell if above 5:31
Thankyou Rick
"Rick Rothstein (MVP - VB)" wrote: Is it possble to highlite the cel in Col A with the color yellow if it is above 5:31 please Select your range or the entire column and click Format / Conditional Formatting... on Excel's menu. On the dialog box that appears, set the first drop-down field to "Cell Value Is", set the second drop-down field to "greater than" and type 5:31 in the third field. Now click the Format button and select the highlight color you want from the Patterns tab and OK your way back to the spreadsheet. That is it.. any cell having a time greater than 5:31 will be shaded in the color you selected. Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula please to highlite every second Row. | Excel Worksheet Functions | |||
| highlite in excel | Excel Discussion (Misc queries) | |||
| If then highlite? | Excel Discussion (Misc queries) | |||
| how do I highlite text within a cell (specific characters) | Excel Discussion (Misc queries) | |||
| Highlite a row | Excel Worksheet Functions | |||
Linear Mode
