| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel windows 97
A user would like to know how if there's a way in Excel
(maybe using VB) to have a cell color change if it meets certain criteria. For example, if the cell value is greater than 10 it turns red. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel windows 97
Have a look at conditional formatting
Formatconditional formatcell value isgreater than 10format as desired -- Don Guillett SalesAid Software " wrote in message ... A user would like to know how if there's a way in Excel (maybe using VB) to have a cell color change if it meets certain criteria. For example, if the cell value is greater than 10 it turns red. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel windows 97
Hi "emcallahan"
No need to us VB when conditional formatting is available. Format Condition Formatting Cell Value Is Greater Than 10 Format Select to taste OK OK -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 with two windows in Windows 7 | Excel Discussion (Misc queries) | |||
| i want all windows in one excel frame (windows in taskbar) | Excel Discussion (Misc queries) | |||
| cannot open exel from windows xp in windows vista and visa versa | New Users to Excel | |||
| can windows vista edit shared document from windows xp | Excel Worksheet Functions | |||
| Page breaks are different in Windows 2000 and Windows XP | Excel Discussion (Misc queries) | |||
Linear Mode
