Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting on a function
Hello, All!
I feel like an idiot because I somehow lost part of the kind replies about using a function for conditional formatting and can't refer to the poster properly. I tried the method and I could not get it to work. I meant to come back to it today but that is when I lost the post. Anyway, I have a list of numbers in A1:A30 and I want to format whichever of them is the minimum in red. Following the posted instructions (as also given by http://office.microsoft.com/en-us/ex...864831033.aspx) I conditionally format A1 in red using the function IF(A1=MIN(A:A)) I select A1, click Format Painter, select A1:30, click Format Painter again Nothing happens except that A1:A30 is outlined by the flickering dotted lines! Certainly, if I put B1 =IF(A1=MIN(A:A),"Minimum"," "), and copy down, the minimum is indicated properly. Pulling out my hair! James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting on a function | Excel Discussion (Misc queries) | |||
Conditional formatting with IF function | Excel Discussion (Misc queries) | |||
Help on a function with Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting (IF function) | Excel Worksheet Functions | |||
Conditional Formatting "OR" function | Excel Worksheet Functions |