colour formatting

I have a table of data. For ease, say there are four columns, titled division (e.g. Africa, Europe), country, region (north/south), and city. The data is all sorted from column to column. I would like, in each column, to have any of the same batch of data one colour and the next batch a...

Hi all, I am working on a matrix consisting of multiple names matched to values. I would like to give everyone a specific RGB colour value (on different sheet). This way, one can easily recognize one another by colour (in addition to names and values in the cell). At this moment I have a...

Hi Everyone, I'm sure this is a basic question, so please excuse my ignorance. I am trying to format the fill colour of a cell based on the value in a different Cell. So for instance if Cell A1 will have a range of values between 1 and 15, I want cell B1 to turn green if the value in cell A1...

Hi, I am currently trying to apply conditional formatting to a number of rows. What I am trying to achieve is that when Row K shows todays date then then entire column highlights yellow. Here is the Conditional Formatting I am using: Formula: =K13=TODAY() Format: Colour yellow Applies to...

<tbody> A B C D E F 1 Home Team Home Goals - Away Goals Away Team W-D-L<strike></strike> 2 NMFC 2 - 1 Chelsea 3 NMFC 3 - 1 Norwich 4 Liverpool 3 - 2 NMFC 5 NMFC 1 - 0 Arsenal 6 Manchester United 2 - 1 NMFC </tbody> Hello, My table...