ExcelBanter - Conditional Formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/214191-conditional-formatting.html)

Jim

Conditional Formatting

Hello,

I did search this question but could not find an answer.

If I want to format f6 only when there is data in a a6: what formula do I
enter?

Thank you

Jonathan Cooper

Conditional Formatting

=if(A6<"",1,0)

"Jim" wrote:

Hello,

I did search this question but could not find an answer.

If I want to format f6 only when there is data in a a6: what formula do I
enter?

Thank you

B. R.Ramachandran

Conditional Formatting

Hi Jim,

=NOT(ISBLANK(F6))

Regards,
B. R. Ramachandran

"Jim" wrote:

Hello,

I did search this question but could not find an answer.

If I want to format f6 only when there is data in a a6: what formula do I
enter?

Thank you

B. R.Ramachandran

Conditional Formatting

Hi Jim,

Sorry for the typo. I meant
=NOT(ISBLANK(A6))

B. R. Ramachandran

"Jim" wrote:

Hello,

I did search this question but could not find an answer.

If I want to format f6 only when there is data in a a6: what formula do I
enter?

Thank you

David Biddulph[_2_]

Conditional Formatting

You don't need the IF(...,1,0)
=A6<"" will do.
--
David Biddulph

"Jonathan Cooper" wrote in
message ...
=if(A6<"",1,0)

"Jim" wrote:

Hello,

I did search this question but could not find an answer.

If I want to format f6 only when there is data in a a6: what formula do I
enter?

Thank you

All times are GMT +1. The time now is 07:06 PM.