Thank you for this. I understood the conditional/absolute references, or
thought I did, but I didn't realize that the relative reference could be
divided up; meaning, I was putting something like =C25, instead of =$C25.

For those who don't understand the difference, as I didn't, the dollar sign
in front of the 'C' means that the column 'C' will always be the reference
(absolutely defined), while the row (the '2' without the dollar sign) will
change with each row being evaluated (relatively defined).

The tutorials linked above are also pretty decent, though I didn't sit all
the way through any of them.

Again, thanks for this clarification and example.

"MacHerb" wrote:

The answer can be found here
http://www.free-training-tutorial.co...ormatting.html

The key is when setting the conditional cell remove the the absolute row
reference. Example: I want A2:B12 to turn blue if C2:C12 is greater than 5.

I highlight A2:B12
Select Conditional FormattingManage Rules
Select new rule
Select Use formula to determine which cells to format
Place cursor in text field or click on cell selection box
Select first cell in condition column (C2)
Enter formula =$c$25
Then remove the $ in front of the 2 so that the formula reads: =$C25
Set the format to desired color (Blue)
Click Ok
Click Apply.

It worked for me in highlighting my grade book by letter grade. At a glance
i see the A's B's and C's.

Hope this helps.

"Nickelberry" wrote:

I'm trying to apply a format as a table and it is not available why not and
how do I get it where I can apply it

"Patti F" wrote:

How can I format an entire column using conditional format? I keep getting an
error message when I choose the column.