Hi there,
I am using Excel 2007, but, trying to keep it reasonably simple, to work backwards with Excel 2003. I am fairly okay with some Conditional Formatting, but this one has me a bit stumped!
I have setup a spreadsheet, which I would like to apply a Conditional Formatting looking at two values from two different cells and apply formatting to another cell.
For example;
Cell A2 = £14.43
Cell B2 = £15.12
Cell C2 = £0.00
Using Conditional Formatting, I would like cell B2 to show as Red text, as it is higher than A2, but it is to ignore C2, on this occasion, as its value is £0, but that may not always be the case.
Then, that Conditional Formatting I would like to apply down Column A2:A10 and the same for Column B and C. So, one cell is always checking two other cells, in the same row, to see if it is the highest value and if it is, apply as Red text.
I can email/supply a copy of the spreadsheet I have setup already, if that would help.
Thanks for your time!
- Peter
I am using Excel 2007, but, trying to keep it reasonably simple, to work backwards with Excel 2003. I am fairly okay with some Conditional Formatting, but this one has me a bit stumped!
I have setup a spreadsheet, which I would like to apply a Conditional Formatting looking at two values from two different cells and apply formatting to another cell.
For example;
Cell A2 = £14.43
Cell B2 = £15.12
Cell C2 = £0.00
Using Conditional Formatting, I would like cell B2 to show as Red text, as it is higher than A2, but it is to ignore C2, on this occasion, as its value is £0, but that may not always be the case.
Then, that Conditional Formatting I would like to apply down Column A2:A10 and the same for Column B and C. So, one cell is always checking two other cells, in the same row, to see if it is the highest value and if it is, apply as Red text.
I can email/supply a copy of the spreadsheet I have setup already, if that would help.
Thanks for your time!
- Peter
