Excel Cell colour changes
Okay I know I can use conditional formatting on a cell depending on the value within that cell however I want to change its colour depending on the value of an adjacent cell and seeing as Excel is not my forte I wondered if anyone there would know?
Wes
Re: Excel Cell colour changes
Instead of applying the formatting based on the cell's own value, base on the formula of your choice.
Re: Excel Cell colour changes
or you can write a visual basic formula i did used to know how to do it but it has been a while will look in the old books if you like
Re: Excel Cell colour changes
There is probably an easier way but, if I can't see an obvious function, I tend to use a bit of VBA.
The following subroutine checks if A2 is greater than 1. If it is then it changes the colour of A1 to red
Sub change_colour
If cells(1,2).value>1 then
Range("A1").Select
Selection.Interior.ColorIndex=3
End If
End Sub
Attach it to a macro button or key press. If you have a lot of data a for/next loop can easily be added.