Thread: Conditional format based on a different column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ArcticWolf ArcticWolf is offline
external usenet poster
  
Posts: 70
Default Conditional format based on a different column
Hi,

How can I apply a conditional format to values in column Z if there is a
(text) value in column E? If there is no value in column E then apply no
format.
If value in column Z <2 no format; <4 background colour Gold, textfont
Black; 4 background colour Red textfont Black.

Thanks in advance,

AW
Reply With QuoteReply With Quote