Advanced Conditional Formating

[OldRookie]

I’m running Excel 2003 Version 11 and the conditional formatting that’s available will change formats in a cell based on values in that cell. I trying to find a way to change the color pattern in a range of cells based on the corresponding value in a different range of cells. I don’t want to make a macro to do this. Does anyone know of a way to do this?

 

[MountainFog]

You can do this by using Absolute References. Can you provide a sample workbook that explains your problem more?

 

[etaf]

can you give a more detailed example of what you need
for example

if you want A2 to change colour - but based on a value in say C2
then select A2
then use a formula
=$C2 = " value you want to change cell A2 colour "

Book2
	A	B	C	D
1
2
3			fred
4
5
6			fred
7
8
9
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A11	Expression	=C2="Fred"	text	NO

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A2:A100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=C2 = "Fred" )

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[OldRookie]

Thank you for your help.

Unfortunately the computer I’m working with is running Excel 2003 V11 and it’s not connected to the internet. Also a photograph of my screen is too large to upload. I’ll try to describe it better.

When I have a 0 in cell E8. I want the fill/pattern color in cell D8 to turn green.
I’m trying this conditional formating in D8:
Formula Is: =“$E8=0”
Then for the format I’m choosing the fill color of green. I place a 0 in E8 and the color of D8 doesn’t change. I think I’m close but doing something slightly wrong.

 

[etaf]

Formula Is: =“$E8=0”
should be
Formula Is: =$E8=0
No inverted commas

i cant remember how you access formula in version 2003 - i think its pretty much the same - only can have 3 rules - but so long ago now since i used

by using "" its telling excel its text and not a formula
same in any formula if you use "0" thats not zero that text

 

[OldRookie]

Ahhh, there it is! Worked perfectly.

Thank you very much.

 

[etaf]

you are welcome