priority: Conditional format vs cell style

[OneLooseCrank]

hi all,
I'm using a conditional format to colour a column depending on what is selected from data validation in the first row. The code for the conditional format is as follows:
=OR(T$1='KS3 HOD'!$S$4,T$1='KS3 HOD'!$U$4,T$1='KS3 HOD'!$W$4)
The format is to colour the row where the condition is met. However, I've create some custom cell styles that are symbolic to the user of the nature of the data. I would like the cell style to take priority over the conditional formatting, but this is not the case. Can anyone advise how to achieve this?
Thanks,
OLC

 

[Joe4]

Conditional Formatting always takes precedence over other formatting.
The other thing I can think of is to scrap the Conditional Formatting, and try to do something with VBA instead.

 

[Eric Golf]

Hi OneLooseCrank,

If the Custom cell styles could be applied using Conditional formatting then you should be able to prioritise between the two styles.

Hope this helps,

Eric.

 

[Joe4]

If the Custom cell styles could be applied using Conditional formatting then you should be able to prioritise between the two styles.

Good point!

You can have multiple Conditional Formatting conditions, and prioritize them.
So I guess the question is if this Custom Style is something that can be applied via Conditional Formatting (and if it is applied via some tangible condition).

 

[OneLooseCrank]

Well, I don't know VBA...
I am using conditional formatting to set the column colour depending on what term is selected in the first row. The term is important to a weighted average function (because it applies the weighting) and so has to be selected, but the column colour is only there to indicate visually which term the grades were recorded in - it's just a visual aid. The cell style selection is designed to indicate through colouring the cell if a student was absent when the work was set. Maybe it doesn't have to be a fill colour... Maybe it could do something else to indicate absence. Unfortunately, the cell must be left blank if the student has not submitted the work (this is because there is a custom weighted average function. Anything other than a cumulative grade will disrupt its calculation) so making the content bold or italic wouldn't work. We do not attribute an absentee as a score of zero so there will be no grade present in an absentee's cell. There are other extraneous factors to choose from in the cell style also, for instance non-submission or incomplete, so multiple styles are needed to indicate different things.
Not sure how to juggle this one.