| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional format based on adjacent cell value
Greetings all. I am trying to use conditional formatting for a cell based on
the value of the adjacent cell. So, I want cell T1 to change to red if U1 = "No". I tried Formula is =IF(U1 = "No"), but I get a formula error. Could this be done with a Macro instead? Thank you. Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional format based on adjacent cell value
for cell g1 formula is
=h1="no" -- Don Guillett Microsoft MVP Excel SalesAid Software "Greg Snidow" wrote in message ... Greetings all. I am trying to use conditional formatting for a cell based on the value of the adjacent cell. So, I want cell T1 to change to red if U1 = "No". I tried Formula is =IF(U1 = "No"), but I get a formula error. Could this be done with a Macro instead? Thank you. Greg |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional format based on adjacent cell value
Conditional formatting requires your formula to return a simple true or
false. To that end just get rid of the if and you are good... =U1 = "No" or =upper(u1) = "NO" makes it non case sensitive... -- HTH... Jim Thomlinson "Greg Snidow" wrote: Greetings all. I am trying to use conditional formatting for a cell based on the value of the adjacent cell. So, I want cell T1 to change to red if U1 = "No". I tried Formula is =IF(U1 = "No"), but I get a formula error. Could this be done with a Macro instead? Thank you. Greg |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional format based on adjacent cell value
Thanks Jim, that worked like a charm.
"Jim Thomlinson" wrote: Conditional formatting requires your formula to return a simple true or false. To that end just get rid of the if and you are good... =U1 = "No" or =upper(u1) = "NO" makes it non case sensitive... -- HTH... Jim Thomlinson "Greg Snidow" wrote: Greetings all. I am trying to use conditional formatting for a cell based on the value of the adjacent cell. So, I want cell T1 to change to red if U1 = "No". I tried Formula is =IF(U1 = "No"), but I get a formula error. Could this be done with a Macro instead? Thank you. Greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting based on adjacent cell? | Excel Worksheet Functions | |||
| Conditional Formatting Based on Value of Adjacent Cell | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on adjacent cell value | Excel Discussion (Misc queries) | |||
| How to do a conditional formatting based on an adjacent cell | Excel Discussion (Misc queries) | |||
| I want to format a cell based on an adjacent cells value | Excel Discussion (Misc queries) | |||
Hybrid Mode
