Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting
I would like the lowest value of columns d ,e, & f to be bold. Some of the
cells have text. Thank you, Dan |
#2
|
|||
|
|||
On Mon, 10 Oct 2005 13:46:04 -0700, "dbrumit"
wrote: I would like the lowest value of columns d ,e, & f to be bold. Some of the cells have text. Thank you, Dan Highlight columns D:F Format/Conditional Formatting Cell Value Is Equal To =MIN($D:$F) Format/Font/Bold OK OK If there is an error in the range, then nothing will be formatted bold. If that is a problem, you could set up two conditions: have the first format RED, for example, if there is an error, and the Second Bold for the MIN number. For condition 1, after highlighting columns D:F, use the Formula Is: Parameter Formula Is: =TRUE=ISERROR(D1) Format/Font Bold Color Red OK OK and use the above for Condition 2 --ron |
#3
|
|||
|
|||
Hi, Try this: select your data then use this formula in conditional formatting, =D1=MIN(D:F) and choose BOLD as your format. D1 being the first cell in your data. Hope this helps! JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=474890 |
#4
|
|||
|
|||
Hi,
Starting with the topmost cell in column D (say D2) select the entire range (say D2:F102), and use the following formula in "Conditional Formatting": "Formula Is" =D2=MIN(D$2:D$102) and format appropriately. Regards, B. R. Ramachandran "dbrumit" wrote: I would like the lowest value of columns d ,e, & f to be bold. Some of the cells have text. Thank you, Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |