conditional format question

H

Harvey Waxman

Is it possible to format a cell on the basis of the contents of a different
cell?

Thanks
 
J

JE McGimpsey

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Macro to copy table of contents to a new doc 0
Conditional Formatting question.... 1
Visio: copy text of a master shape to User-define Cells (Variable) 0
Printing Outline view - formatting lost 0
Changing row background from external program 0
Conditional Formatting 2
Place picture in Excel cell 0

Top