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
Results 1 to 4 of 4
-
New Lounger
- Join Date
- Oct 2001
- Posts
- 16
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2001-10-30 20:39Changing Colour of Cells (Excel '97)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Bronze Lounger
- Join Date
- Jun 2001
- Location
- New York, New York, Lebanon
- Posts
- 1,434
- Thanks
- 1
- Thanked 1 Time in 1 Post
2001-10-30 20:46Re: Changing Colour of Cells (Excel '97)
Jukebox
Check the Conditional Formatting under the Format menu.
If you need examples let us know.
Wassim<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>
-
New Lounger
- Join Date
- Oct 2001
- Posts
- 16
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2001-10-30 20:59Re: Changing Colour of Cells (Excel '97)
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
-
Bronze Lounger
- Join Date
- Jun 2001
- Location
- New York, New York, Lebanon
- Posts
- 1,434
- Thanks
- 1
- Thanked 1 Time in 1 Post
2001-10-30 21:04Re: Changing Colour of Cells (Excel '97)
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<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>
