Is it possible to format a cell on the basis of the contents of a different cell? Thanks
H Harvey Waxman Jun 9, 2007 #1 Is it possible to format a cell on the basis of the contents of a different cell? Thanks
J JE McGimpsey Jun 9, 2007 #2 Harvey Waxman said: Is it possible to format a cell on the basis of the contents of a different cell? Click to expand... Sure. Select cell B1. Choose Format/Conditional Formatting. Change the dropdown/input box to read CF1: Formula is =A1<100 Format1: <font>/<green>
Harvey Waxman said: Is it possible to format a cell on the basis of the contents of a different cell? Click to expand... Sure. Select cell B1. Choose Format/Conditional Formatting. Change the dropdown/input box to read CF1: Formula is =A1<100 Format1: <font>/<green>
H Harvey Waxman Jun 10, 2007 #3 JE McGimpsey said: Sure. Select cell B1. Choose Format/Conditional Formatting. Change the dropdown/input box to read CF1: Formula is =A1<100 Format1: <font>/<green> Click to expand... That was easy Thanks
JE McGimpsey said: Sure. Select cell B1. Choose Format/Conditional Formatting. Change the dropdown/input box to read CF1: Formula is =A1<100 Format1: <font>/<green> Click to expand... That was easy Thanks
Thanks