Thread: Conditional Formatting based on text in another cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Eade Dave Eade is offline
external usenet poster
  
Posts: 53
Default Conditional Formatting based on text in another cell
Hi,

I want to CF the cell A1 based on a text value in Cell F1

Do I just use the CF formula $F1=Cancelled

Cancelled being the test, if true I want A1 formatted?
Reply With QuoteReply With Quote