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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

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,181,332
Messages
5,929,362
Members
436,664
Latest member
plobo4

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