Conditional Formatting

U

umba-sr

Hi,

Is there a way to apply conditional formatting to a range of cells that
depend not on their own value, but on a value of another cell? If not with
Conditional Formating, then with Functions or, in final case, Programming?
Also, can I make more than three conditions in Conditional Formatting?

I know questions look ridiculous, but I need to find a way to do it. If not,
then I better start programming.
 
R

Ron Coderre

You should still be able to use Conditional Formatting...

<Format><Conditional Formatting>
Click the first drop-down
Change the selection from "Cell Value is" to "Formula is"
Then reference the cell you want to compare to:

Example:
If you want cell B1 to have red text if A1 is greater than zero:
Formula Is: =A1>0


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
U

umba-sr

Thanks, it does help, but I sort of knew that already.
But allow me to give you my own example. It's a little bit more complex.

I have 30 columns with dates as labels, which means 30 days in month. Now,
bellow labels I have amount of money inserted every day. What I want is for
every column to change its color basing on present date of which I have
formula Today() on top.
So, If I open file on April 5, I want columns of before this date to turn
blue, column of April 5 to turn red, and columns of future dates to turn
yellow or remain at automatic, doesn't matter. I managed to do that with
label cells of course, but I need a fast way of how to do it with cells
bellow, cause I don't want to format every single column for every month of
the year.

Sorry for all the trouble and text you have to read. It would be OK if you
couldn't assist me, anyway.
 
P

Pete_UK

Assuming your dates are in B1 to AD1 (30 of them), and that your
monetary data is thus in B2 to AD20 (say), then highlight B2:AD20,
ensuring that you start with cell B2, and click Format | Conditional
Format and select Formula Is and enter this:

=B$1<TODAY()

and choose Blue on the Patterns tab. Then click Add for the second
condition and enter Formula Is;

=B$1=TODAY()

and choose Red on the Patterns tab. Then for your third condition,
Formula Is:

=B$1>TODAY()

and select Yellow on the Patterns tab.

Hope this helps.

Pete
 
U

umba-sr

It does help, of course. Thanks a lot. Silly me, I never thought of putting
just one dollar sign for rows.
Can you just tell me if there is a way to make more than three conditions
with Conditional Formatting, or in any other way similar to this one.
 
Top