Conditional formatting

[cyrusir]

Hi all,

i was wondering if someone could help me vba conditional formatting, i have never used it before.

What i would like to do is compile a macro that would search through a work book (or on a worksheet by worksheet basis if thats the only way it can be done?) and highlight the following:

- colour the font of cells that originate from another worksheet
- colour the font of cells that originate from a different place in the same worksheet
- colour the font of cells that comprise a total (probably all would include a sum formula
- colour the background of cells that are hardcoded i.e. do not contain a formula

i have no idea where to being and would appreciate some help!

Thanks in advance

[Richard Buttrey]

Hi,

How about something like:

Please Login or Register  to view this content.

Change the colours as appropriate
HTH

[cyrusir]

hi richard that seems to work a treat, thank you very very much

[cyrusir]

just wondering

is there anyway to set the condition relating to cells whose values originate from within the same sheet so that it will only colour them if they are equal to another cell as opposed to containing a formula that uses a number of cells in the same sheet?

[Richard Buttrey]

Hi,

Can you be a bit more explicit. i.e. do you want to colour them if the formula is just say =A1 but not if it's say =A1+A2, or something like =VLOOKUP() etc?

Rgds

[cyrusir]

hi richard

yes i just want to colour them if they are =a1, but nothing more than that.

oh and also what code would i need to change so that the macro just runs on the active sheet Richard? as opposed to cycling thro the entire work book

[Richard Buttrey]

Hi,

I cycled it through all worksheets since that was what your OP requested. To limit it to just the active sheet take out the For x = 1 to Sheets.Count loop and the Sheets(x).activate.

The revised code should just colour the =A1 type cells.

Please Login or Register  to view this content.

[cyrusir]

thats brilliant thank you Richard