Conditional Formatting

[pedroc]

If column A returns a N/A value can I conditonally format the remaining columns in that row to fill a particular colour?

Many thanks

Pedroc

 

[villy]

highlight all columns rather than A then in CF Formula Is type in:

=IsError(A1)

 

[VoG]

Try this: select the range then apply the CF

Excel Workbook
	A	B	C	D	E	F
1	04/08/2011	05/08/2011	2
2	#N/A
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =ISNA($A1)	Abc

 

[Yahya]

like this

Excel Workbook
	A	B	C	D	E	F
2	Headers 1	Headers 2	Headers 3	Headers 4	Headers 5	Headers 6
3	Yahya
4	#N/A
5	New
6	#N/A
Sheet5

Excel 2007

select the table
from conditional formatting -> new rule
write this formula

=ISNA($A3)

 

[Weaver]

Yes you can

Select your range from the top left and note the first row number. For example, say it's 2

in conditional formatting, use 'formula', the formula being:

=iserror($A2)

then set your colour

HTH

 

[pedroc]

Thanks Villy - could i do the same if there were given text in Column A - for example if i typed No in column A?

 

[Weaver]

=$A2="No"