Colouring of Cells.

arnolan

New Member
Joined
Aug 31, 2002
Messages
1
Is there a formula you can use to colour a cell depending on a value?

And can this be used to colour a cell that the formula isnt in? eg colour cell D4 red when the formula is in cell D10

Thanks
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
welcome to the board!

conditional formatting is what you need - check it out in the help file.

As an example:
Book11
ABCD
1CheckValueTRUE/FALSECond.Format
210TRUE
3
4
5
Sheet1


Conditional formats check either cell values, or formulas that evaluate to true or false. if the condition is tru, the format is applied.

In the example, the formula in B2 is posted to show how you would set up the value check so that it returns true when the condition is met. If you put this formula in a conditional format (under format | conditional formatting...), you can format cells cepending on the value of a1 - that's wht I did in cell c2.

hope that helps...post back with more info about what you are trying to do...

Paddy
 

Forum statistics

Threads
1,144,354
Messages
5,723,884
Members
422,524
Latest member
wirkkarn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top