LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 28
Default Conditional Formatting - stuck on formula

Hi - Thanks beforehand!

I'm stuck on a formula for a condition and hoping someone can help.

=AND($H23="stalled",$G23<TODAY())

Is currently what I have and it works... I need to add an additional part to
this formula that looks for if $G23 is blank and/or if it's past today().

So if it's "stalled" has no date or the date has not occurred then true,
else if "stalled" and has date that has occurred then false.
 
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
Stuck on a Formula cranen Excel Discussion (Misc queries) 2 February 3rd 10 08:04 PM
stuck up with a formula TUNGANA KURMA RAJU Excel Discussion (Misc queries) 1 August 31st 06 09:41 AM
Stuck - need help on an if/conditional formula Amy Excel Discussion (Misc queries) 1 January 16th 06 03:46 AM
Stuck on formula Decreenisi Excel Discussion (Misc queries) 1 January 10th 06 12:20 PM
Formula Help... I'm really stuck here Miko Excel Discussion (Misc queries) 4 September 7th 05 08:36 PM


All times are GMT +1. The time now is 04:39 AM.

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

About Us

"It's about Microsoft Excel"