Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
i am working on a spread sheet. i have set up that everytime i enter a number
the cell next to or two down adds 250 when i enter the first number is it possible to make the cell with the added 250 turn red. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
not completely sure i understand your question, but you could put in a
conditional format that basically says: "if this cell's value is more that 250, turn red." to do this, click the cell that you want to turn red. Then on the main menu, click FORMAT CONDITIONAL FORMATTING... Then set it to "Cell value is.....greater than....250". Then click the format button and on the patterns tab, click the red color. clidk OK..and OK hope this helps, dk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change color of all cells with formula or are part of a formula | Excel Discussion (Misc queries) | |||
Input color and formula color | Excel Discussion (Misc queries) | |||
Formula which changes color | Excel Discussion (Misc queries) | |||
hit F2, want the color coded formula to appear in formula bar not | Excel Worksheet Functions | |||
Use color in a IF formula | Excel Discussion (Misc queries) |