Conditional formatting on other cell value

G

gstremer

Hi all,

Standard conditional formatting of a cell is based solely on the cell's
own value.

Is it possible to make it depend on the value of another cell? I am
not frightened by a VBA solution.

Thanks,

G
 
P

Peo Sjoblom

It's not dependent on the cell's own value, only if you use the cell value
option, from dropdown you can select formula is instead and refer to another
cell, like if the selected cell is A2 and you want to format depending on
that B2 is greater than five, format > conditional formatting, select
formula is and use

=B2>5

then click the format button and select format and finally click OK twice


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
 
T

tim m

You should be able to use another cells value.
When you do your standard conditional formatting instead of using 'cells
value is', click on the drop down arrow and choose 'formula is' Then you can
put the address of the cell you want to look at and put a value and enter a
formula to check for the value.
 
T

Trevor Shuttleworth

Use the Formula is option rather than Cell value in Conditional Formatting

Regards

Trevor
 
S

somethinglikeant

Not true,

and no real need for VBA

Go to
Format > Conditional Formatting

use the drop down box to select formula is

Here you can use any formula to link to a range of other cells or a
single cell

Quick Example
Select th whole column A
go to FC...

formula is =$D1=1, set format as per usual

any corresponding row in column D with value 1 will be formatted.

clevert use of similar relative or fixed referencing does ll the work
for you

hope this helps

http://www.excel-ant.co.uk
 
B

britwiz

gstremer said:
Hi all,

Standard conditional formatting of a cell is based solely on the cell's
own value.

Is it possible to make it depend on the value of another cell? I am
not frightened by a VBA solution.
Click to expand...

Hi gstremer

No need for vba.

In the Conditional Formatting dialog box, click the drop down arrow
next to "Cell Value Is" and click "Formula Is".

Enter (if your current cell is A1, for example) =B1="Y", choose your
format and away you go.

You can use regular operators and functions in your formula.

Regards

Steve
 
Top