Nick has attended:
Excel Intermediate course
Excel Advanced course
Conditional formatting on Mulitple Cells
Hi,
I have 3 columns of data 10 rows long. (A-C ; 1-10). What I want to do is add Conditional Formatting to cells B1:B10 and C1: C1:C10 based on what's in A1:10 and B1:10 respectively.
So if B1 is less than A1 give me a down arrrow (or whatever) and if C1 is greater than B1 give me an up arrow.
I can do them all individually but is there a way to highlight all cells and apply a formula? I have quite a lot...
Thanks.
RE: Conditional formatting on Mulitple Cells
Hi Nick,
Thank you for your question.
Can you please put a small spreadsheet together with say 3 rows of data for each of your columns and send it to:
sk@stl-training.co.uk
Then I can look at the best answer for you.
Regards
Simon
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
