We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Conditional formatting [closed]

asked 2013-01-16 11:48:44 +0200

anonymous user


updated 2013-02-03 09:39:59 +0200

qubit gravatar image

I want to be able to apply the conditional back ground colour to a another cell but based on the condition in the original cell. Example: in a simple house expenditure spreadsheet I can highlight all cells that have "CR" using the stndard conditional formatting. However I also want the same highlight colour to be applied two columns across which is where the amount would be entered.

Any suggestions?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 01:12:06.701547

2 Answers

Sort by » oldest newest most voted

answered 2013-01-16 15:29:05 +0200

w_whalley gravatar image

A conditional format condition can be a formula and the formula can refer to another cell. For example if cell A1's background changes to blue_background when its content is CR, then cell C1's background can also change to blue_background. The conditional formatting for cell C1 would be Condition 1, Formula is A1="CR", cell style blue_background.

edit flag offensive delete link more

answered 2013-01-17 12:58:13 +0200

astronomer gravatar image

Thanks for this reply. In the back of my mind I reckoned it could be done from the days, long ago, when I used Excel, but couldn't work it out on my own. Excellent.

PS This is my first use of AskLiBo so I'm not sure how to register my approval. I've use the tick mark next to my original question so I hope that's the right thing to do.

edit flag offensive delete link more


@astronomer, you did exactly the right thing. Karma for you!

qubit gravatar imagequbit ( 2013-01-17 20:54:55 +0200 )edit

Question Tools


Asked: 2013-01-16 11:48:44 +0200

Seen: 1,461 times

Last updated: Jan 17 '13