Home |
Search |
Today's Posts |
#1
|
|||
|
|||
conditional formattings
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thankyou very much!!
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |