Range of one cell backcolor in excell 2003
Dear Sir Madame
I am doing a function in Excel 2003 that takes three cells as range data-type.
the function all it does is to see if two of the cells equal to the third one. if yes I want to color the background as green
Can anyone reply to my request?
Thanks in advance
p.s. I am using the RTD method of excel as receiving real time data from generator
I am doing a function in Excel 2003 that takes three cells as range data-type.
the function all it does is to see if two of the cells equal to the third one. if yes I want to color the background as green
Can anyone reply to my request?
Thanks in advance
p.s. I am using the RTD method of excel as receiving real time data from generator
ASKED:
Feb 8, 2008 5:02 PM GMT
UPDATED:
February 19, 2008 8:14:26 AM GMT
RELATED QUESTIONS
- VB Active Cell problem
- Data entry and calculations in the same cell
- Inputing greek symbol in concatenated text
- EXCEL 2003 and VLOOKUP help in calculating percentage in third cell
- One formula for a single column in Excel 2003
- VBS - Taking input from one spreadsheet and output to another
- Excel 2003 Macros with Org Chart Parent
- VB6 cannot shutdown Excel.exe except by ending VB program
- Need Cobol 88 equivalent
- Sending Multiple Files to the AS/400 Automatically
Answer Wiki:
Have you checked out the 'Conditional Formatting' option?
Under 'Format'.. -> 'Conditional Formatting'.
yes i have tried but i wana do it using VBA
thanks for your help ;)
Under 'Format'.. -> 'Conditional Formatting'.
yes i have tried but i wana do it using VBA
thanks for your help ;)
45 pts.
To see other answers submitted to the Answer Wiki View Answer History.
