Changing Colour of Cells (Excel ’97)

Topic

New Reply

Does anyone know how to change the colour of a cell using a formula? I.e. Place an IF formula in a cell to check text in another cell and change the cells colour accordingly!

Thanks
Jamie

Reply | Quote

Replies

Jukebox

Check the Conditional Formatting under the Format menu.

If you need examples let us know.

Wassim

Reply | Quote

I could do it with conditional formatting but it only allows for three different formats to be applied, i need at least 5, thats why i want to do it by using the IF formula because i could nest up to 7 of them!

Jamie

Reply | Quote

Jukebox

I am not sure you can do it with an If formula. You see a Formula may change the value of the cell, but not its formatting. This is why MS gave us the Conditional Formatting…

Try VBA if you can.

Again if you need any examples we’ll give them to you.

Wassim

Reply | Quote