PDA

View Full Version : Comparison formatting



Alasbabylon
09-08-2009, 12:29 PM
I have a spreadsheet with products and prices. Is there a way to compare each value in column B with the same row value in column H, then highlight the cell with the lower value?
I am using Word 2003 and 2007, so I'm saving everything in 2003 format.

nst1107
09-08-2009, 01:43 PM
Use conditional formating in each column. I've done it here in your workbook.