Thread: formula to color fill a cell if number over assigned value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default formula to color fill a cell if number over assigned value
Select the cell
Format - COnditional Format
Set the conditions and format as desired.
--
HTH,
Barb Reinhardt



"rhuckeby" wrote:

I want to automatically have the cell filled with bright green if the value
present in the cell is equal to or greater than $20.00
Reply With QuoteReply With Quote