excel conditional formatting

  rsturbo 11:03 13 Jul 2006
Locked

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 2006

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 2006

thanks very much

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

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Photoshop CC 2018 released with new Curvature Pen and better brush tools

Camera tips to take better iPhone photos

Les meilleures applications de covoiturage 2017