View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Forum freak \(at work\) Forum freak \(at work\) is offline
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