Thread: if cell is blank, color another cell?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
savbci savbci is offline
external usenet poster
  
Posts: 10
Default if cell is blank, color another cell?
I have 2 fields A1 and B1
If B1 is blank I want the text in A1 to turn red. Otherwise it will remain
black.
Later if B1 is filled in then A1 will turn back to it's original state
(black).
How do I do this?

Reply With QuoteReply With Quote