|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 20th, 2006, 06:47 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Color to a Cell
Hello all,
I would like to be able to change the color of a cell when a specific value is attained. E.g. If the statement 1+1=2 is TRUE then make the cell where the 2 is, Green. If the statement is FALSE then change the color to red. Thank you in advance 
|
|
#2
July 20th, 2006, 07:02 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding Color to a Cell
Try conditional Formatting See attached link which explains it http://www.meadinkent.co.uk/conditional-formatting.htm VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=563146
|
|
#3
July 24th, 2006, 02:02 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding Color to a Cell
THANK YOU!!
VBA Noob wrote: Try conditional Formatting See attached link which explains it http://www.meadinkent.co.uk/conditional-formatting.htm VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=563146
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with this conditional IF statement | C-Dawg | General Discussion | 3 | May 15th, 2006 06:01 PM |
| Custom functions calculating time arguments Help Desperate | Bill_De | Worksheet Functions | 12 | April 25th, 2006 02:22 AM |
| adding a formula in a cell but when cell = 0 cell is blank | Mike T | Worksheet Functions | 5 | May 31st, 2005 01:08 AM |
| GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |
| IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
Linear Mode
