LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
rexmann
 
Posts: n/a
Default Conditional format

Hi all

This one might be a bit tricky (or not!). I know how to conditonal format
but is it possible to use the value in one cell but display the formatting
in another or alternatively format an entire record but only referencing one
cell

Example in a database of names and details conditional format the date of
birth as between sep1973 and Nov1974 - but the formatting would effect the
whole row or rows.

I thought some kind of IF statement. Alternative is there syntax which
displays the different value_IF sections?

Any help (even if it is to say it is not possible) is greatly appreciated

Rexmann
 
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 numbers in chart datatable MB Charts and Charting in Excel 3 May 29th 05 03:37 PM
conditional format of data tables in charts [email protected] Charts and Charting in Excel 2 January 25th 05 03:56 PM
pivot chart format Valeria Charts and Charting in Excel 1 January 14th 05 01:19 PM
format one data series, with error bars, and use it as default JBR Charts and Charting in Excel 2 January 9th 05 04:03 PM
Adding more than three Conditions to 'Conditional Formatting' David McRitchie Excel Discussion (Misc queries) 1 November 27th 04 06:03 PM


All times are GMT +1. The time now is 08:03 AM.

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"