another excel question

[chearn]

Again, probably something simple so here it goes!

I have 2 columns, if the data in column 2 is greater that 50 I need the data in the 1st column to be shaded.

My mind is gone this morning, and I cannot think of the formula.

thanks
C

 

[andshep]

Use conditional formatting for th cells you want to change the colour of, with the criteria

Condition 1 Formula is =B2>50 (for example)

Hope this helps.

 

[Richard Schollar]

Use Conditional Formatting:

Select the range in column A you want shaded then go Format>Conditional Formatting and select "Formula Is" then type

=B1>50

and then select whatever format you want to apply. You will have to adjust the row reference (ie here B1) to whatever is your first row in your selection.

Best regards

Richard

 

[Banker1]

Why not use conditional formatting?

1 Select the first cell in Column 1
2 Open the Conditional Formatting Menu
3 Select Formula is
4 In the Formula box type: =B1>50 (I'm assuming your Columns are A & B)
5 Select the format you wish to apply
6 Click OK
7 Copy and Paste Special Formats to the remaining cells in Column 1