| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Forgive me for the lack of excel termonology I know, I just use the program
I have had much success with Conditional Formatting when it involves numbers, formulas, and the like. However the current task leaves me in a quandry. I am attempting to yield Green for a "Y" or Yes, Yellow for a Blank or "", or Red for a "N". I am not sure if I can just use an IF statement that will yield the conditional "Cell Fill" though. Any help on the letter value issue? -- Generally confused, but serving my Lord wholeheartedly |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
1. Select the range/column
2. From menu FormatConditional Formatting 3. For Condition1Select 'Cell valu is' and enter ="Y" Click Format ButtonPattern and select your color (say Green) 4. Click on Add button. 5. For Condition2Select 'Cell valu is' and enter ="" Click Format ButtonPattern and select your color (say Yellow) 6. Click on Add button. 7. For Condition1Select 'Cell valu is' and enter ="N" Click Format ButtonPattern and select your color (say Red) 8. Hit OK If this post helps click Yes --------------- Jacob Skaria "RMartin" wrote: Forgive me for the lack of excel termonology I know, I just use the program I have had much success with Conditional Formatting when it involves numbers, formulas, and the like. However the current task leaves me in a quandry. I am attempting to yield Green for a "Y" or Yes, Yellow for a Blank or "", or Red for a "N". I am not sure if I can just use an IF statement that will yield the conditional "Cell Fill" though. Any help on the letter value issue? -- Generally confused, but serving my Lord wholeheartedly |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
Thanks. Didn't even occurr to me to set 3 specific Formats
Question. The Green and the Red work (i.e. Y=Green, N=Red) however the yellow for the ="" is not coming up. Any ideas? Yellow is not necessary, just eye candy and eye catching for what information is not yet entered. I suspect the non-formatted cell is just as catching. -- Generally confused, but serving my Lord wholeheartedly "Jacob Skaria" wrote: 1. Select the range/column 2. From menu FormatConditional Formatting 3. For Condition1Select 'Cell valu is' and enter ="Y" Click Format ButtonPattern and select your color (say Green) 4. Click on Add button. 5. For Condition2Select 'Cell valu is' and enter ="" Click Format ButtonPattern and select your color (say Yellow) 6. Click on Add button. 7. For Condition1Select 'Cell valu is' and enter ="N" Click Format ButtonPattern and select your color (say Red) 8. Hit OK If this post helps click Yes --------------- Jacob Skaria "RMartin" wrote: Forgive me for the lack of excel termonology I know, I just use the program I have had much success with Conditional Formatting when it involves numbers, formulas, and the like. However the current task leaves me in a quandry. I am attempting to yield Green for a "Y" or Yes, Yellow for a Blank or "", or Red for a "N". I am not sure if I can just use an IF statement that will yield the conditional "Cell Fill" though. Any help on the letter value issue? -- Generally confused, but serving my Lord wholeheartedly |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
If the cells are genuine blanks; in 2007 from 'New formatting rule' window
....from 'Format only cells with' select 'Blanks' and select yellow color.. If this post helps click Yes --------------- Jacob Skaria "RMartin" wrote: Thanks. Didn't even occurr to me to set 3 specific Formats Question. The Green and the Red work (i.e. Y=Green, N=Red) however the yellow for the ="" is not coming up. Any ideas? Yellow is not necessary, just eye candy and eye catching for what information is not yet entered. I suspect the non-formatted cell is just as catching. -- Generally confused, but serving my Lord wholeheartedly "Jacob Skaria" wrote: 1. Select the range/column 2. From menu FormatConditional Formatting 3. For Condition1Select 'Cell valu is' and enter ="Y" Click Format ButtonPattern and select your color (say Green) 4. Click on Add button. 5. For Condition2Select 'Cell valu is' and enter ="" Click Format ButtonPattern and select your color (say Yellow) 6. Click on Add button. 7. For Condition1Select 'Cell valu is' and enter ="N" Click Format ButtonPattern and select your color (say Red) 8. Hit OK If this post helps click Yes --------------- Jacob Skaria "RMartin" wrote: Forgive me for the lack of excel termonology I know, I just use the program I have had much success with Conditional Formatting when it involves numbers, formulas, and the like. However the current task leaves me in a quandry. I am attempting to yield Green for a "Y" or Yes, Yellow for a Blank or "", or Red for a "N". I am not sure if I can just use an IF statement that will yield the conditional "Cell Fill" though. Any help on the letter value issue? -- Generally confused, but serving my Lord wholeheartedly |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
Scracth that, The first drop down had "Blanks" as an option. I chose that
and it fixed my issue. Thank you for your time. Ross -- Generally confused, but serving my Lord wholeheartedly "Jacob Skaria" wrote: 1. Select the range/column 2. From menu FormatConditional Formatting 3. For Condition1Select 'Cell valu is' and enter ="Y" Click Format ButtonPattern and select your color (say Green) 4. Click on Add button. 5. For Condition2Select 'Cell valu is' and enter ="" Click Format ButtonPattern and select your color (say Yellow) 6. Click on Add button. 7. For Condition1Select 'Cell valu is' and enter ="N" Click Format ButtonPattern and select your color (say Red) 8. Hit OK If this post helps click Yes --------------- Jacob Skaria "RMartin" wrote: Forgive me for the lack of excel termonology I know, I just use the program I have had much success with Conditional Formatting when it involves numbers, formulas, and the like. However the current task leaves me in a quandry. I am attempting to yield Green for a "Y" or Yes, Yellow for a Blank or "", or Red for a "N". I am not sure if I can just use an IF statement that will yield the conditional "Cell Fill" though. Any help on the letter value issue? -- Generally confused, but serving my Lord wholeheartedly |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
What version of Excel are you using?
-- Biff Microsoft Excel MVP "RMartin" wrote in message ... Forgive me for the lack of excel termonology I know, I just use the program I have had much success with Conditional Formatting when it involves numbers, formulas, and the like. However the current task leaves me in a quandry. I am attempting to yield Green for a "Y" or Yes, Yellow for a Blank or "", or Red for a "N". I am not sure if I can just use an IF statement that will yield the conditional "Cell Fill" though. Any help on the letter value issue? -- Generally confused, but serving my Lord wholeheartedly |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
Office 2007
-- Generally confused, but serving my Lord wholeheartedly "T. Valko" wrote: What version of Excel are you using? -- Biff Microsoft Excel MVP "RMartin" wrote in message ... Forgive me for the lack of excel termonology I know, I just use the program I have had much success with Conditional Formatting when it involves numbers, formulas, and the like. However the current task leaves me in a quandry. I am attempting to yield Green for a "Y" or Yes, Yellow for a Blank or "", or Red for a "N". I am not sure if I can just use an IF statement that will yield the conditional "Cell Fill" though. Any help on the letter value issue? -- Generally confused, but serving my Lord wholeheartedly |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
Ok, I see you have a solution so, carry on!
-- Biff Microsoft Excel MVP "RMartin" wrote in message ... Office 2007 -- Generally confused, but serving my Lord wholeheartedly "T. Valko" wrote: What version of Excel are you using? -- Biff Microsoft Excel MVP "RMartin" wrote in message ... Forgive me for the lack of excel termonology I know, I just use the program I have had much success with Conditional Formatting when it involves numbers, formulas, and the like. However the current task leaves me in a quandry. I am attempting to yield Green for a "Y" or Yes, Yellow for a Blank or "", or Red for a "N". I am not sure if I can just use an IF statement that will yield the conditional "Cell Fill" though. Any help on the letter value issue? -- Generally confused, but serving my Lord wholeheartedly |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Hybrid Mode
