If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Highlight automatically a specific cell
i am working on a spreadsheet and need some help, it's hard to explain what i
want but i'll try my best, here goes! I have a sheet and on it i have several amounts in different cells like this:- 20.36 19.36 17.24 17.54 19.81 20.12 I want the cell with the lowest amount in it to show in a different colour font automatically, so 17.24 in the third column would show in red and the rest in black, then if i changed the amount in the first column to 16.99 it would automatically change to red and the amount in the third column would go back to black as it would no longer be the lowest amount. is there a way this can be done. |
#2
|
|||
|
|||
Highlight automatically a specific cell
formatconditional formattingformula is=a2=min($a$2:$g$2)format as
desired -- Don Guillett Microsoft MVP Excel SalesAid Software "Frances Holden" wrote in message ... i am working on a spreadsheet and need some help, it's hard to explain what i want but i'll try my best, here goes! I have a sheet and on it i have several amounts in different cells like this:- 20.36 19.36 17.24 17.54 19.81 20.12 I want the cell with the lowest amount in it to show in a different colour font automatically, so 17.24 in the third column would show in red and the rest in black, then if i changed the amount in the first column to 16.99 it would automatically change to red and the amount in the third column would go back to black as it would no longer be the lowest amount. is there a way this can be done. |
Thread Tools | |
Display Modes | |
|
|