IF statement --- repost
Hi, ALL:
Not sure why my previous post didn't show up. This is a repost. Basically, if I shade a cell with color green (cell format\pattern), I want to return a pure number of 1. Otherwise, return a value of 0. How to achieve this by using a if statement? Thanks, Jorge |
IF statement --- repost
This was the reply to your previous post.
First we need to know what the Conditional Formatting is that determines the cell to be green. You should be able to use the same formula. __------------------ Basically, your if statement will be something like this: =IF(A10,1,0) But we still need to know how the conditional formatting is set up before an accurate formula can be written. Regards, Paul wrote in message oups.com... Hi, ALL: Not sure why my previous post didn't show up. This is a repost. Basically, if I shade a cell with color green (cell format\pattern), I want to return a pure number of 1. Otherwise, return a value of 0. How to achieve this by using a if statement? Thanks, Jorge |
IF statement --- repost
You'll need to use a macro/UDF:
See http://cpearson.com/excel/colors.htm In article .com, " wrote: Hi, ALL: Not sure why my previous post didn't show up. This is a repost. Basically, if I shade a cell with color green (cell format\pattern), I want to return a pure number of 1. Otherwise, return a value of 0. How to achieve this by using a if statement? Thanks, Jorge |
IF statement --- repost
PCLIVE:
No, the OP didn't say that he/she used Conditional Formatting... In article , "PCLIVE" wrote: This was the reply to your previous post. First we need to know what the Conditional Formatting is that determines the cell to be green. You should be able to use the same formula. __------------------ Basically, your if statement will be something like this: =IF(A10,1,0) But we still need to know how the conditional formatting is set up before an accurate formula can be written. Regards, Paul wrote in message oups.com... Hi, ALL: Not sure why my previous post didn't show up. This is a repost. Basically, if I shade a cell with color green (cell format\pattern), I want to return a pure number of 1. Otherwise, return a value of 0. How to achieve this by using a if statement? Thanks, Jorge |
IF statement --- repost
Sorry JE, My mind read faster than my eyes and I didn't re-read it the
second time. Thanks for the correction. "JE McGimpsey" wrote in message ... PCLIVE: No, the OP didn't say that he/she used Conditional Formatting... In article , "PCLIVE" wrote: This was the reply to your previous post. First we need to know what the Conditional Formatting is that determines the cell to be green. You should be able to use the same formula. __------------------ Basically, your if statement will be something like this: =IF(A10,1,0) But we still need to know how the conditional formatting is set up before an accurate formula can be written. Regards, Paul wrote in message oups.com... Hi, ALL: Not sure why my previous post didn't show up. This is a repost. Basically, if I shade a cell with color green (cell format\pattern), I want to return a pure number of 1. Otherwise, return a value of 0. How to achieve this by using a if statement? Thanks, Jorge |
All times are GMT +1. The time now is 06:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com