Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Conditional Formatting Help
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Ayo, post: 6407708"] I am trying to do a conditional format on the rngInsitedata range. If the cell value is past due I want the cell to be Red Fill and font color white. Please help. With rngInsitedata .FormatConditions.Add(xlCellValue, xlEqual,"=Past Due") With .Borders .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = 6 End With With .Font .Bold = True .ColorIndex = 3 End With End With [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Conditional Formatting Help
Top
