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: 38
Default Conditional formating based on blank cell

I have data in the few cells in the row. I would like to format different
color based on one cell in the row, for example:
A B C D E F
12 12 56 43 87 Oct 12, 2009
76 98 56 34 21

I want to highlight row 2 as F2 is blank (there is no date).

Thanks in advance for your help.
Kimti
 
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
How can I refer to a blank cell when using conditional formating? Kman Excel Discussion (Misc queries) 2 June 23rd 06 05:22 AM
Conditional formating -identify blank cell Simon Smith Excel Worksheet Functions 3 March 9th 06 10:48 PM
Set conditional formating for cell based on value in different cel D4137 Excel Discussion (Misc queries) 2 May 5th 05 08:15 PM
Conditional Formating based on another cell SMac Excel Discussion (Misc queries) 5 March 10th 05 07:17 PM
conditional formating for a blank cell wsoung Excel Discussion (Misc queries) 5 March 9th 05 10:15 PM


All times are GMT +1. The time now is 01:25 PM.

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"