LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Conditional formatting - with 2 conditions

Hi

If cells C1 and B1 are empty C1 fill colour is "no fill"
I want cell C1 fill colour to change from "no fill" to yellow when B1 is not
empty and C1 remains empty.
However I want C1 fill colour to revert to "no fill" if data is entered into
C1 regardless of the condition of B1

Can this be done?

Kenny W
XP pro
Office 2003


 
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
PLEASE HELP: More then 3 conditions on Conditional Formatting Marco Excel Discussion (Misc queries) 3 April 18th 07 10:18 AM
Conditional formatting should allow more than three conditions. Joshua, Technical Editor Excel Discussion (Misc queries) 1 July 26th 06 12:44 PM
conditional formatting with four conditions Ring eye Excel Worksheet Functions 2 January 11th 06 12:35 AM
Conditional formatting with more than 3 conditions. jeffg Excel Worksheet Functions 0 October 5th 05 02:04 PM
more than 3 conditions in conditional formatting - possible? rob curtis Excel Discussion (Misc queries) 11 August 17th 05 04:02 PM


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