View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daren Daren is offline
external usenet poster
 
Posts: 162
Default Comparing Two Different Cells Using Conditional Format

Hello,

I have a date formatted as 3/14/2001 in column U and a code ZZ in column AA.
In column AA, I want to use conditional formatting that will show red if
there is not a date in column U but there is a code in column AA. How can I
do this?

Thanks!