Filling a Cell with Color

  • Thread starter Thread starter RF
  • Start date Start date
R

RF

I know how to use conditional formatting to change the text color in a
cell. But I'm at a loss as to how to make a cell "fill" with a color.

It must be something simple.
 
You should still be able to use Conditional Formatting...

After clicking the [format...] button, there are 3 tabs:
• Font
• Border
• Patterns<-------Use this one

Does that help?
***********
Regards,
Ron

XL2003, WinXP
 
Yea, sure did. I knew that but forgot.

But I have another question. Hmmmm.

Let's say I put a value in a cell. Call it 8

Then let's say I put a value in another cell. 8 again. When I put a
value in the second cell that matches the value in the first cell is
there a way to make the first cell change to a fill color I want?

This is confusing because it doesn't involve a formula.

Thanks again for the fill answer.


You should still be able to use Conditional Formatting...

After clicking the [format...] button, there are 3 tabs:
• Font
• Border
• Patterns<-------Use this one

Does that help?
***********
Regards,
Ron

XL2003, WinXP


RF said:
I know how to use conditional formatting to change the text color in a
cell. But I'm at a loss as to how to make a cell "fill" with a color.

It must be something simple.
Click to expand...
Click to expand...
 
A1 has the number 8

Select A1 and CF>Formula is: =A1=B1

Format to the color you want.

Enter 8 in B1 and A1 will fill.


Gord Dibben MS Excel MVP

Yea, sure did. I knew that but forgot.

But I have another question. Hmmmm.

Let's say I put a value in a cell. Call it 8

Then let's say I put a value in another cell. 8 again. When I put a
value in the second cell that matches the value in the first cell is
there a way to make the first cell change to a fill color I want?

This is confusing because it doesn't involve a formula.

Thanks again for the fill answer.


You should still be able to use Conditional Formatting...

After clicking the [format...] button, there are 3 tabs:
• Font
• Border
• Patterns<-------Use this one

Does that help?
***********
Regards,
Ron

XL2003, WinXP


RF said:
I know how to use conditional formatting to change the text color in a
cell. But I'm at a loss as to how to make a cell "fill" with a color.

It must be something simple.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top