Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Format if cell is not blank

One way would be to just set the FONT of that column to BOLD, and/or some
color or type other than what you use on the rest of the sheet.........it
would only appear if and when some note is typed in, otherwise will stay
blank.........

Vaya con Dios,
Chuck, CABGx3



"Sunryzz" wrote:

I have a spreadsheet with a column for notes. There are not very many
entries in this column so I want to set up conditional formatting to change
the color if a note is entered. However, that note could be anything at all.
So, basically I want to change the color with ANY entry. Does anyone know
how to do that?

Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format of a cell profG Excel Discussion (Misc queries) 1 January 16th 06 03:02 PM
Conditional Format to highlight blank cell DaveMoore Excel Worksheet Functions 4 June 23rd 05 10:10 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Custom format that shows blank cell if another cell is empty Zdenek Moravec Excel Discussion (Misc queries) 1 March 25th 05 11:45 AM
Using Jet to read excel file returns blank for last cell - sometim Ron Excel Discussion (Misc queries) 1 December 9th 04 08:21 AM


All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"