View Single Post
  #4   Report Post  
Not Very Good With Excel
 
Posts: n/a
Default

Thankyou very much Chip!

Not Very Good With Excel (Deborah)

"Chip Pearson" wrote:

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
wrote in message
...
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