excel conditional formatting

  rsturbo 11:03 13 Jul 06

i have 2 columns of numerical data (1 quote from each company) i need to conditionally format the cells (highlight yellow) to show me who has the lowest quote. can somebody give me an idiots guide how to do this?

thanks for any help

  VoG II 11:12 13 Jul 06

Say your data is in columns A and B starting at Row 1.

Click in A1, Format, Conditional formatting. The first box should say Cell Value is. In the second select Less than, in the third enter =$B1 click Format and select the formatting you want and OK your way out. In B1 do the same but enter =$A1.

Click in A1, click the Format Painter (paintbrush) on the toolbar, select the rest of column A to copy the formatting down. Do the same for column B.

  rsturbo 09:22 24 Jul 06

thanks very much

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…