hi all
i have a sheet where cells 'A' are full of numbers aswell as cells 'B'.
i'm wanting to set up a formula so that IF cell 'A' is less that 6.50 'AND' cell 'B' is greater than 9, change the colour of cell 'A' to red.
i can see i can use condtional formatting for one of these ie if A is less than 6.50, but I cant seem to set it up for the two sets of criterias.
Thanks in advance
Gemma
Bookmarks