| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
hi Frank
nice one, worked a treat, cheers Rexmann "Frank Kabel" wrote: Hi try the following: - lets assume A1 is the cell and you want to format A1:X1 - select A1:X1 - goto the conditional format dialog. - enter 'Formula is' - enter the formula =$A1=value - choose your format -- Regards Frank Kabel Frankfurt, Germany "rexmann" schrieb im Newsbeitrag ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format numbers in chart datatable | Charts and Charting in Excel | |||
| conditional format of data tables in charts | Charts and Charting in Excel | |||
| pivot chart format | Charts and Charting in Excel | |||
| format one data series, with error bars, and use it as default | Charts and Charting in Excel | |||
| Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
Hybrid Mode
