| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Q Conditional Formatting
Greetings:
Is it possible to apply conditional formatting to a cell which is NOT the cell being modified? For example, if I enter a 5 in cell A1, can Excel change the background color of cell B1 to yellow? (I know this can be done with VBA, but I'm wondering if there is a way to do it with conditional formatting.) Feedback is appreciated. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Q Conditional Formatting
hi Marty,
select b1, format | conditional Format, change to "the formula is" and type a1=5 format as you need hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Marty" escreveu: Greetings: Is it possible to apply conditional formatting to a cell which is NOT the cell being modified? For example, if I enter a 5 in cell A1, can Excel change the background color of cell B1 to yellow? (I know this can be done with VBA, but I'm wondering if there is a way to do it with conditional formatting.) Feedback is appreciated. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Q Conditional Formatting
Marcelo: Thanks for the response, but it didn't work.
When I re-opened the conditional formatting box, it now looks like this: ="A1=5" Excel added the equal sign on the left and the quotes. What did I do wrong? "Marcelo" wrote: hi Marty, select b1, format | conditional Format, change to "the formula is" and type a1=5 format as you need hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Marty" escreveu: Greetings: Is it possible to apply conditional formatting to a cell which is NOT the cell being modified? For example, if I enter a 5 in cell A1, can Excel change the background color of cell B1 to yellow? (I know this can be done with VBA, but I'm wondering if there is a way to do it with conditional formatting.) Feedback is appreciated. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Q Conditional Formatting
The formula should be:
=A1=5 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Marty" wrote in message ... Marcelo: Thanks for the response, but it didn't work. When I re-opened the conditional formatting box, it now looks like this: ="A1=5" Excel added the equal sign on the left and the quotes. What did I do wrong? "Marcelo" wrote: hi Marty, select b1, format | conditional Format, change to "the formula is" and type a1=5 format as you need hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Marty" escreveu: Greetings: Is it possible to apply conditional formatting to a cell which is NOT the cell being modified? For example, if I enter a 5 in cell A1, can Excel change the background color of cell B1 to yellow? (I know this can be done with VBA, but I'm wondering if there is a way to do it with conditional formatting.) Feedback is appreciated. Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Q Conditional Formatting
That worked. Thanks.
"RagDyeR" wrote: The formula should be: =A1=5 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Marty" wrote in message ... Marcelo: Thanks for the response, but it didn't work. When I re-opened the conditional formatting box, it now looks like this: ="A1=5" Excel added the equal sign on the left and the quotes. What did I do wrong? "Marcelo" wrote: hi Marty, select b1, format | conditional Format, change to "the formula is" and type a1=5 format as you need hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Marty" escreveu: Greetings: Is it possible to apply conditional formatting to a cell which is NOT the cell being modified? For example, if I enter a 5 in cell A1, can Excel change the background color of cell B1 to yellow? (I know this can be done with VBA, but I'm wondering if there is a way to do it with conditional formatting.) Feedback is appreciated. Thanks. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Q Conditional Formatting
=A1=5
-- regards from Brazil Thanks in advance for your feedback. Marcelo "Marty" escreveu: Greetings: Is it possible to apply conditional formatting to a cell which is NOT the cell being modified? For example, if I enter a 5 in cell A1, can Excel change the background color of cell B1 to yellow? (I know this can be done with VBA, but I'm wondering if there is a way to do it with conditional formatting.) Feedback is appreciated. Thanks. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Q Conditional Formatting
Thanks for the feed-back.
-- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Marty" wrote in message ... That worked. Thanks. "RagDyeR" wrote: The formula should be: =A1=5 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Marty" wrote in message ... Marcelo: Thanks for the response, but it didn't work. When I re-opened the conditional formatting box, it now looks like this: ="A1=5" Excel added the equal sign on the left and the quotes. What did I do wrong? "Marcelo" wrote: hi Marty, select b1, format | conditional Format, change to "the formula is" and type a1=5 format as you need hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Marty" escreveu: Greetings: Is it possible to apply conditional formatting to a cell which is NOT the cell being modified? For example, if I enter a 5 in cell A1, can Excel change the background color of cell B1 to yellow? (I know this can be done with VBA, but I'm wondering if there is a way to do it with conditional formatting.) Feedback is appreciated. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting a range with conditional formatting | Excel Worksheet Functions | |||
| conditional formatting glitches | Excel Discussion (Misc queries) | |||
| Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
| cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
Linear Mode
