If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excell conditional formatting

Fol20 · 2012-08-17 11:57:11

Hi all, Im trying to set a rule where you have 2 columns A,B The formula i would like to set is: If A = any NUMBER/Letter then B is filled to RED by default If B = y then B is filled to Green Is it possilbe to set up radio boxes or a check box in excel? Thanks for any help.

Options

17-08-2012 12:57pm

#1

Fol20

Registered Users Posts: 3,624 ✭✭✭

Join Date: August 2006

Posts: 3251

Hi all,

Im trying to set a rule where you have 2 columns A,B

The formula i would like to set is:

If A = any NUMBER/Letter
then B is filled to RED by default
If B = y
then B is filled to Green

Is it possilbe to set up radio boxes or a check box in excel?

Thanks for any help.

0

Comments

Options
#2 17-08-2012 6:25pm
[Deleted User]
Posts: 0 ✭

Join Date: -

Posts: 0

set 2 seperate rules

rule with formula

=a1="y"

set to green

rule 2

=a1<>"y"

set format to red.

make sure there is no referencing i.e. $ in the cell ref. do on one cell e.g. in row a in this case and copy formatting using the format painter.

====

yes, you can use check-boxes and radio buttons in excel. use the control toolbox bar. getting them to do stuff is another thing - google is your friend - easy to find tutorials on the web.

0