Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello
My boss has set me a couple of problems and unfortunately my knowledge of Excel is lacking. So any one who can bail me out....... 1. Is it possible to restrict an entry to either one of two cells but not both? I had thought Conditional formatting but having searched around the net have not found an answer. Maybe there isn't one. 2. On the subject of conditional formatting, if B2 had a date in it what would the formula in C2 be for the cell to turn red after say 100 days from the date in B2? Forgive me if this is something easily done...... Many thanks for reading this though Mungo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |