LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 151
Default Conditional Formatting Formula

Hi

Try this:

=IF(B1<"",AND(C1="Completed"))

rinse and repeat for all your other cells.

HTH
Mick.
 
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
Conditional formatting Formula using AND Anton Excel Worksheet Functions 4 October 6th 08 07:23 AM
conditional formatting formula Gary Keramidas Excel Programming 5 January 19th 07 04:10 PM
Conditional Formatting formula tankerman Excel Discussion (Misc queries) 2 December 22nd 06 05:34 PM
Conditional Formatting: Formula is Sue Excel Worksheet Functions 2 March 30th 06 09:21 AM
conditional formatting with FORMULA... Please HELP! Chris M Excel Discussion (Misc queries) 1 August 20th 05 12:28 AM


All times are GMT +1. The time now is 06:43 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"