Coloring Cell Blocks

  • Thread starter Thread starter Troy
  • Start date Start date
T

Troy

Is there a function that searches a range for a value < 19
and if a value is found then color that cell block gray?
 
Troy said:
Is there a function that searches a range for a value < 19
and if a value is found then color that cell block gray?
Click to expand...

Not sure what you mean by "cell block".
You should look at Conditional Formatting (on the Format menu).
You would need a formula such as
=(OR($A$1<19,$B$1<19,$A$2<19,$B$2<19))
which would look for a value less than 19 in the range A1:B2.
 
-----Original Message-----


Not sure what you mean by "cell block".
You should look at Conditional Formatting (on the Format menu).
You would need a formula such as
=(OR($A$1<19,$B$1<19,$A$2<19,$B$2<19))
which would look for a value less than 19 in the range A1:B2.


.
Click to expand...
What I am looking for is if B7 is < 19 then color the
following cells in gray A7, B7, C7, D7, E7, F7, G7, and H7.
 
Troy said:
What I am looking for is if B7 is < 19 then color the
following cells in gray A7, B7, C7, D7, E7, F7, G7, and H7.
Click to expand...

Select A7:H7.
Format > Conditional formatting
Change first box to "Formula Is".
In second box type this formula:
=($B$7<19)
Click the "Format" button and choose your grey formatting.
Click two "OK" buttons to get out, and the job is done.

It is important to have an absolute reference ($B$7, rather than B7) in this
situation, so that all 8 of your cells base their conditional formatting on
the same cell.
 
Back
Top