Conditional Formatting

  • Thread starter Thread starter smith.james0
  • Start date Start date
S

smith.james0

How do i conditional format a large amount of cells? I need each cell t
change colour when a certain value is inputted into that cell
 
If the format will be the same for all the cells, i.e., all red when >100,
then simply select all the cells in question, and the cell with the focus
(colored white in selection) should be the cell of reference in the
conditional formula.

For example, select A1:A100.
A1 is white, and the other cells are black.

then <Format> <Conditional Format>
Click "Formula Is", and enter this formula:
=A1>100
Click "Format", and choose your format choices.
Then <OK> <OK>

All the cells that were in the selection will now have the same conditional
format as A1.
 
You must log in or register to reply here.

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

Question about conditional formatting of zeros in Excel 0
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Conditional Formatting - Excel 2003 2
Excel Conditional Formatting Removal 7
condition format 2
Font changed by Conditional Formatting 1
Conditional formatting in Excel 2010 2
How can I set more than 3 conditions for cells? 2

Back
Top