| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formating cells i Excel based on other cells values
is it possible to use conditional formating based on the value in other cell
that is can I use conditional formating in cell A3 based on the value in cell A1 -- Iceland is almost on the top of the world:) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formating cells i Excel based on other cells values
The answer is YES!
HTH -- AP "Elias Petursson" a écrit dans le message de news: ... is it possible to use conditional formating based on the value in other cell that is can I use conditional formating in cell A3 based on the value in cell A1 -- Iceland is almost on the top of the world:) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formating cells i Excel based on other cells values
Elias,
On the conitional formating box change the 1st box to Formula. Marcelo - Brazil "Elias Petursson" escreveu: is it possible to use conditional formating based on the value in other cell that is can I use conditional formating in cell A3 based on the value in cell A1 -- Iceland is almost on the top of the world:) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formating cells i Excel based on other cells values
"Elias Petursson" wrote:
is it possible to use conditional formating based on the value in other cell that is can I use conditional formating in cell A3 based on the value in cell A1 Yes, perhaps a quick tinker to illustrate .. Select A3 Click Format Cond Formatting Under Condition 1, make it as: Formula is: =A110 Click Format button Patterns tab Green? OK Click OK at the main dialog Test it out .. Input a figure 10 into A1, A3 should be filled green Change A1 to a fig less than 10, A3's green fill would disappear -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use conditional formating to incicate blank cells in excel | Excel Worksheet Functions | |||
| Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) | |||
| Expanding conditional formating with reference cells changing | Excel Discussion (Misc queries) | |||
| Formatting cells in Excel for certain Values to appear certain Col | Excel Worksheet Functions | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Hybrid Mode
