| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change background row color with change of date in a cell
Oh, ok, I see what you mean:
1/31/2006 2/1/2006 Well, the posted example didn't "demonstrate" that that is how this is to be used. <g Biff "Biff" wrote in message ... How? MOD(30,2)=0 MOD(31,2)=1 Biff "CaptainQuattro" <CaptainQuattro.27xv42_1147847423.0779@excelforu m-nospam.com wrote in message news:CaptainQuattro.27xv42_1147847423.0779@excelfo rum-nospam.com... If you use Mod(day... you will get two adjacent same-coloured rows at the end of a month with 31 days. -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=542781 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Change cell colour by date | New Users to Excel | |||
| Cell Background Color Change according to numerical value | Excel Discussion (Misc queries) | |||
| Change cell color dependin on date ... | Excel Worksheet Functions | |||
| How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
Hybrid Mode
