HELP(URGENT)
 

HI, I have to get a print out or the values have to highlighted in the
worksheet.
It has to read 3 cells,

Example: If values in each cell in columnA =600 and cells in column A
+ columnB cells in columnC then highlight them

HELP(URGENT)
 

I'm not sure I understand the problem the way it's written, but you can
change cell highlighting through conditional formatting. It is easy and
quick to learn from the Help index in Excel.
--
big-bob


"Iceman" wrote:

HI, I have to get a print out or the values have to highlighted in the
worksheet.
It has to read 3 cells,

Example: If values in each cell in columnA =600 and cells in column A
+ columnB cells in columnC then highlight them

HELP(URGENT)
 

Here's one way to get the highlights up via CF ..

I'll presume you want the entire row within cols A to C highlighted
if the conditions specified are satisfied.

Assuming data in row1 down

Select cols A to C
(ensure A1 is active by selecting the col headers from "A" to "C")

Click Format Conditional Formatting
Make the settings for Condition 1 as:
Formula is:
=AND($A1=600,SUM($A1:$B1)$C1)
Click "Format" Patterns tab Light Brown fill OK
Click OK at the main dialog

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Iceman" wrote:
HI, I have to get a print out or the values have to highlighted in the
worksheet.
It has to read 3 cells,

Example: If values in each cell in columnA =600 and cells in column A
+ columnB cells in columnC then highlight them

HELP(URGENT)
 

You can do this with conditional formatting. Why is YOUR request more URGENT
than others?

--
Don Guillett
SalesAid Software

"Iceman" wrote in message
ups.com...
HI, I have to get a print out or the values have to highlighted in the
worksheet.
It has to read 3 cells,

Example: If values in each cell in columnA =600 and cells in column A
+ columnB cells in columnC then highlight them