Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[oldfogy]

Can any one help please?

I have a spreadsheet that I would like the result of "K22" to show either "Red or Blue"

Basically:
K19 = a static figure of £70.88
K15 = the sum of 2 other cells
K22 = the sum of (K15-K19)

So, what I would like is,
If K22 is less than K19, then the result is shown in RED, or BLUE if more than K19

Thanks

[exo]

Hi, these may be of interest. I assume you are using Excel.

http://www.juiceanalytics.com/writing/2006/08/exploring-data-in-excel-with-conditional-formatting/

http://www.cpearson.com/excel/colors.htm

http://www.cpearson.com/excel/CFColors.htm

exo

[MikeS]

Hi

Conditional formating is what you want.  Look on the format menu put in the first condition  K22<K19  (red) condition and choose the  format button where you can choose font, colour etc  Then click add and put inthe second condition K22>=k19 (blue)

Hope this helps

[oldfogy]

Thanks Exo.

With looking at your links it reminded me of the "Conditional Formating" tool and with a little experiment I was able to achieve what I wanted to do, so thanks again.

***************************************************

Sorry for the late response but I do not seem to be getting any email alerts at the moment.
EDIT: emails are being received ( but not untill "several hours" later.


Warning - while you were typing a new reply has been posted. You may wish to review your post.

*****************************************************

Thanks Mike,
Thats more or less what I did do.