Thread: Change fill color based on value of another cell in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Change fill color based on value of another cell in Excel
Select the cell (say B1) and pull-down:
Format Conditional Formatting... and pick formula is

=(A1="") and select you format (say fill red)

Then if A1 is empty, then B1 will show as red, otherwise not red.
--
Gary''s Student


"ForensicAccountant" wrote:

How would I set/change the fill color of one cell of an Excel spreadsheet
based on the value of another cell on the same Excel spreadsheet?
Reply With QuoteReply With Quote