| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating
Excell 2003.
If the results in "Say" cell Q12 is <= 0 then B12:Q12 all of the text turns red or the background cell color changes to grey... Conditional formation is great but when there is a loto of columns I get lost looking for the data in the first column when the data in the last column is the one that has the conditional formating. Many thanks in advance Bob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating
Slect the range b12:q12.
Foarmat Conditional Format change to the formula is on the drop down botton, and type =$Q$12=0 format as you need hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Bob" escreveu: Excell 2003. If the results in "Say" cell Q12 is <= 0 then B12:Q12 all of the text turns red or the background cell color changes to grey... Conditional formation is great but when there is a loto of columns I get lost looking for the data in the first column when the data in the last column is the one that has the conditional formating. Many thanks in advance Bob |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating
sorry for the mistake use <=0 instead of =0
-- regards from Brazil Thanks in advance for your feedback. Marcelo "Marcelo" escreveu: Slect the range b12:q12. Foarmat Conditional Format change to the formula is on the drop down botton, and type =$Q$12=0 format as you need hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Bob" escreveu: Excell 2003. If the results in "Say" cell Q12 is <= 0 then B12:Q12 all of the text turns red or the background cell color changes to grey... Conditional formation is great but when there is a loto of columns I get lost looking for the data in the first column when the data in the last column is the one that has the conditional formating. Many thanks in advance Bob |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating
Thanks works like a champ...
Bob "Marcelo" wrote: Slect the range b12:q12. Foarmat Conditional Format change to the formula is on the drop down botton, and type =$Q$12=0 format as you need hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Bob" escreveu: Excell 2003. If the results in "Say" cell Q12 is <= 0 then B12:Q12 all of the text turns red or the background cell color changes to grey... Conditional formation is great but when there is a loto of columns I get lost looking for the data in the first column when the data in the last column is the one that has the conditional formating. Many thanks in advance Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formating | New Users to Excel | |||
| Conditional Formating | Excel Worksheet Functions | |||
| Conditional formating | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| Help Please with Conditional FOrmating | Excel Worksheet Functions | |||
Linear Mode
