Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ignore auto format after applying a custom format??
Already confused Probably just me!! I need 2 alter the appearances of the
odd cell, whilst maintaining the auto format day/date settings, but not font colour & borders etc.... I do a monthly "thingo" (schedule), in which, at present, I use auto format 2 complete days & dates - I have rows for Sat & Sun which r not 2 b seen and 2 date, have been using white txt colour so, when printed, u just see a gap - desired effect! Have tried custom format (worked well) but as soon as I used auto fill again it overrode custom (set 4 white txt). Also have tried grouping & hiding (works well, but doesn't leave desired gap between weeks - tried bold outline on bottom border, but NQR still! ~~ Long story short: Does anyone know how to force cells to "go with the flow" of auto formatting, but not 2 show contents 2 achieve what I am after??-- cheers & thx ___ J-Pop :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying format to cells | Excel Discussion (Misc queries) | |||
Applying a cell format within a Formula | Excel Discussion (Misc queries) | |||
Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions |