LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Yogi_Bear_79
 
Posts: n/a
Default Conditonal Format Formula

Need help writing a formula that does this

If IsEmpty(H3) And CurrentCell(G3) <= Today()

The Conditional Format goes in Cell G3. It should check the adjacent cell
H3 for data, if data exists do nothing, if H3 is Empty AND G3 is Less than
or Equal to today, then trip the format.

I'd also like to utilize this code in VBA. Below is a snippet of my code
that applies my current conditional formatting. How would you write the
proper syntax for the statement above so that, every cell in column G is
checking it's adjecent H cell versus all referencing H3?

For Each Sh In ThisWorkbook.Worksheets
shLast = LastRow(Sh)
With Sh.Range("G2:G" & shLast)
.FormatConditions.Add Type:=xlCellValue, Operator:=xlLessEqual,
Formula1:="=TODAY()"
.FormatConditions(1).Font.Bold = True
.FormatConditions(1).Font.ColorIndex = 3
End With
Next


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel represent formula in textural format with values substi. BoneR Excel Worksheet Functions 7 March 31st 05 03:11 PM
How do I copy a conditional format that uses a formula in a serie. TygerJ Setting up and Configuration of Excel 1 March 31st 05 01:07 AM
date format within a cell containing a formula Brushie76 Excel Discussion (Misc queries) 1 January 22nd 05 03:50 AM
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 01:27 AM
How do I format a character from a result of formula in excel? Mohamed Excel Discussion (Misc queries) 2 December 9th 04 09:43 AM


All times are GMT +1. The time now is 07:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"