conditional font color

[ndendrinos2]

hello to all ... I need either a conditional formatting formula or a VBA maco to do this:
I select colum D and format font color white
I add a conditional format to do this: if in adjacent cells(C3:D1000) have a value then change font color to automatic
Hope I explain it well but again I'm 78 so who knows..... thank you

 

[ndendrinos2]

sorry maybe I should add that the change takes place ONLY in the row I'm typing a value

 

[kevin9999]

Not sure if I fully understand - if you mean when you type something into column C then the font in column D returns to automatic? If so, try this (you change the format to automatic in Conditional Formatting):

Book1
	C	D
3	x	abc
4		abc
5		abc
6		abc
7	y	abc
8	z	abc
9		abc
10		abc
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D3:D1000	Expression	=C3<>""	text	YES

 

[ndendrinos2]

sorry maybe I should add that the change takes place ONLY in the row I'm typing a value

please disregard previous ... I think I better explain it like this ....if I enter a value in row C or D then change font color in E in same row to Automatic ...

 

[ndendrinos2]

sorry Kevin I don't blame you for not understanding me correctly ... mea culpa .. I'm Greek and we Greeks confuse people most of the time so allow me to try again
in any given row If I type a value in cells C or D then on the same row in E revert font to black (the whole column id formatted in white) I really thank you for taking the time to reply

 

[ndendrinos2]

maybe this explains it even better

 

[kevin9999]

OK, let's try this:

Book1
	C	D	E
1	Credit	Debit	Cash on hand
2
3	1800.00	10.00	1790.00
4		5.00	1785.00
5		5.00	1780.00
6		3.00	1777.00
7	103.00	2.00	1878.00
8	12.00		1890.00
9	10.00		1900.00
10	19.00		1919.00
11			1919.00
12			1919.00
13			1919.00
14			1919.00
15			1919.00
16			1919.00
17			1919.00
18			1919.00
19			1919.00
20			1919.00
Sheet1

Cell Formulas
Range	Formula
E4:E20	E4	=E3+C4-D4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E3:E20	Expression	=COUNTA($C3:$D3)>0	text	NO

 

[ndendrinos2]

Kevin I am able to replace my formulas in E with yours and they work but the formatting doesn't and maybe it has to do with me using a prehistoric version of XLS?

 

[kevin9999]

I can't remember that far back (2003) as to why the conditional formatting wouldn't work. Just make sure your settings are like those set out below:

 

[ndendrinos2]

I'm afraid that conditional formatting in my old excel version allows only limited "conditions" example: if value is same ... of value is less than ''' and few more but nothing as sophisticated as what you've just posted ... I'm going to call it a night and resume tomorrow ... thank you for your time Kevin