Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all,
In rows 2 to and with 252 of my worksheet cells in colums AK up to and including AR contain dates or blanks. In row 1 the cells in colums AK to and with AR ("header cells") have different interior colors, their text is bold and black except for AO1 and AR1 where the text is bold and white. I want the first cell of a row to have the same interior color and text color of the header cell corresponding with the highest date (I mean: date most in the future) in that row in colums AK to AR. What code do I need? Thanks in advance for your assistance. Jack Sons The Netherlands |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) |