| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Based on Value of Adjacent Cell
Hi,
I see the solution on the boards but it doesn't work for me. Cells: B1 =now() B2 =weekday(b1) C2 Conditional formatting =b2="Monday" Cell B2 is custom formatted "dddd" so it shows the day. If I type "Monday" into cell B2 it works but if I use "weekday(b1)" it doesn't even though "Monday" is in the cell. How do I get conditional formatting to recognize the value Monday as opposed to being confused by the formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting Based on Value of Adjacent Cell
It might look like Monday due to its format, bur Now() is a number. You
could use TEXT(B1,"dddd") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ... Hi, I see the solution on the boards but it doesn't work for me. Cells: B1 =now() B2 =weekday(b1) C2 Conditional formatting =b2="Monday" Cell B2 is custom formatted "dddd" so it shows the day. If I type "Monday" into cell B2 it works but if I use "weekday(b1)" it doesn't even though "Monday" is in the cell. How do I get conditional formatting to recognize the value Monday as opposed to being confused by the formula? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting Based on Value of Adjacent Cell
wrote in message
... Hi, I see the solution on the boards but it doesn't work for me. Cells: B1 =now() B2 =weekday(b1) C2 Conditional formatting =b2="Monday" Cell B2 is custom formatted "dddd" so it shows the day. If I type "Monday" into cell B2 it works but if I use "weekday(b1)" it doesn't even though "Monday" is in the cell. How do I get conditional formatting to recognize the value Monday as opposed to being confused by the formula? Use this conditional format formula: =B2=2 The WEEKDAY function returns a number between 1 and 7. Therefore the underlying value in cell B2 is a number between 1 and 7. Formatting doesn't change this value - it merely changes how it is displayed. Any formula using B2 uses the underlying value. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting Based on Value of Adjacent Cell
The cell is formatted to display Monday, but the actual value in the cell is 2.
Change the conditional formatting to =b2=2. " wrote: Hi, I see the solution on the boards but it doesn't work for me. Cells: B1 =now() B2 =weekday(b1) C2 Conditional formatting =b2="Monday" Cell B2 is custom formatted "dddd" so it shows the day. If I type "Monday" into cell B2 it works but if I use "weekday(b1)" it doesn't even though "Monday" is in the cell. How do I get conditional formatting to recognize the value Monday as opposed to being confused by the formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting based on adjacent cell value | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Return adjacent cell if conditional formatting exists. | Excel Worksheet Functions | |||
| Conditional coloring of Excel cells, based on adjacent cell values? | Excel Worksheet Functions | |||
| How to do a conditional formatting based on an adjacent cell | Excel Discussion (Misc queries) | |||
Linear Mode
