| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Colour cells of specific value?
Hi all,
I want a macro that checks through the current worksheet and colours every cell that has a specified value.. Eg. if F12 has "BAD" typed in it, then F12 should be coloured red.. thanks in advance.. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Colour cells of specific value?
You don't need a macro simply use conditional formatting. select all the
cells on the worksheet and set up the conditional format to be red if the cell contents match your criteria. Mike "rj" wrote: Hi all, I want a macro that checks through the current worksheet and colours every cell that has a specified value.. Eg. if F12 has "BAD" typed in it, then F12 should be coloured red.. thanks in advance.. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Colour cells of specific value?
See http://www.contextures.com/xlCondFormat01.html
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "rj" wrote in message ps.com... Hi all, I want a macro that checks through the current worksheet and colours every cell that has a specified value.. Eg. if F12 has "BAD" typed in it, then F12 should be coloured red.. thanks in advance.. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Colour cells of specific value?
thanx, that would work, but i need it as part of a macro so the changes
take place (and other changes as well) when i click a button.. On Nov 2, 1:32 pm, "Bob Phillips" wrote: Seehttp://www.contextures.com/xlCondFormat01.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "rj" wrote in glegroups.com... Hi all, I want a macro that checks through the current worksheet and colours every cell that has a specified value.. Eg. if F12 has "BAD" typed in it, then F12 should be coloured red.. thanks in advance.. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Colour cells of specific value?
With Range("F12")
If .Value = "BAD" Then .Interior.Colorindex = 3 Else .Interior.Colorindex = xlColorindexNone End If End With -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "rj" wrote in message ups.com... thanx, that would work, but i need it as part of a macro so the changes take place (and other changes as well) when i click a button.. On Nov 2, 1:32 pm, "Bob Phillips" wrote: Seehttp://www.contextures.com/xlCondFormat01.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "rj" wrote in glegroups.com... Hi all, I want a macro that checks through the current worksheet and colours every cell that has a specified value.. Eg. if F12 has "BAD" typed in it, then F12 should be coloured red.. thanks in advance.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding specific cells | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Will excel add cells using colour coding eg Add all red cells | Excel Discussion (Misc queries) | |||
| i want to use the =if function to apply a colour to other cells | Excel Worksheet Functions | |||
| Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) | |||
Linear Mode
