conditional formattings

  • Thread starter Not Very Good With Excel
  • Start date
N

Not Very Good With Excel

How do I use conditional formatting. When I put data in cell C18 I want it
to change the colour of text in cell K18, is this possible?

I would really appreciate some help with this matter.

Thanks
 
C

Chip Pearson

Select cell K18 and then choose Conditional Formatting from the
Format menu. In that dialog, change "Cell Value Is" to "Formula
Is" and enter =LEN($C$18)>0 as the formula and choose the format
you want.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Not Very Good With Excel" <Not Very Good With
(e-mail address removed)> wrote in message
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can i put text in a cell depending on colour 0
Excel does not accept text format! 0
Change the colour of a cell if another named cell is blank 2
conditional formatting update issue 5
Conditional format 1
Conditional Formatting 3
Conditional Formatting Formula 3
CONDITIONAL FORMATTING IN EXCEL 2010 1

Top