ExcelBanter - if and conditional format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if and conditional format (https://www.excelbanter.com/excel-discussion-misc-queries/241064-if-conditional-format.html)

RayNDM83

if and conditional format

Hi,
Is it possible to create this statement in excel:
if a1 is color "red", then a3=a1, if not then a3=a2.
Thanks,
Ray

Bill Kuunders

if and conditional format

Can you use the condition that makes a1 go red?

for instance you enter in a3 ..........
=if(a1<0,a1,a2)

--
Greetings from New Zealand

"RayNDM83" wrote in message
...
Hi,
Is it possible to create this statement in excel:
if a1 is color "red", then a3=a1, if not then a3=a2.
Thanks,
Ray

RayNDM83

if and conditional format

Hi Bill,
No, a user will highlight cell a1 or a2 for me and i need to pick the
hightlighted cell and copy it to a3.
Thank you for taking time on this.
Ray

"Bill Kuunders" wrote:

Can you use the condition that makes a1 go red?

for instance you enter in a3 ..........
=if(a1<0,a1,a2)

--
Greetings from New Zealand

"RayNDM83" wrote in message
...
Hi,
Is it possible to create this statement in excel:
if a1 is color "red", then a3=a1, if not then a3=a2.
Thanks,
Ray

Herbert Seidenberg

if and conditional format

Excel 2007
Identify Interior Colors
http://www.mediafire.com/file/medykn22wkt/08_28_09.xlsm

All times are GMT +1. The time now is 02:33 PM.