Thread: Colour row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Colour row
Hi,

Select the row then

Format|conditional format
Formula us
=$F$14500
Select a colour
Click OK

Mike

"Kjellk" wrote:

How do I format an entire row with yellow background if the value in column F
i s larger than 4500?
Reply With QuoteReply With Quote