excel conditional formatting

  rsturbo 11:03 13 Jul 06
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 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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac