HELP(URGENT)

I

Iceman

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
 
B

big-bob

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.
 
M

Max

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
 
D

Don Guillett

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